View: Orders

RotoID: OE0520
Tables: OEORDH, OEORDH1
Protocol: Header, Key auto generate
DLL:OEORDH

Compositions: 6

RotoID Tables Title DLL
OE0500 OEORDD Order Details OEORDD
OE0999 GENSTUB
OE0180 OECOINO Order Comments/Instructions OECOINO
OE0740 OETERMO Order Payment Schedules OETERMO
OE0526 OEORDQ Order from Quotes OEORDQ
OE0522 OEORDHO Order Optional Fields OEORDHO

Keys: 9

Title Fields
Order Uniquifier Key ORDUNIQ
Order Number Key ORDNUMBER
Customer Number CUSTOMER
Type/Complete TYPE, COMPLETE, ORDUNIQ
Customer/Order CUSTOMER, ORDNUMBER
Reference/Order REFERENCE, ORDNUMBER
Customer/PO No. CUSTOMER, PONUMBER
Customer/OnHold/Type CUSTOMER, ONHOLD, TYPE
Sage CRM Opportunity COMPANYID, OPPOID

Fields: 406

Field Index Type Title Attributes Presentation
ORDUNIQ 1 BCD*10.0 Order Uniquifier E A K R 
ORDNUMBER 2 String*22 Order Number E A  Mask: %-22C
CUSTOMER 3 String*12 Customer Number E A  Mask: %-12C
CUSTGROUP 4 String*6 Customer Group Code E A  Mask: %-6C
BILNAME 5 String*60 Bill-To Name E A 
BILADDR1 6 String*60 Bill-To Address Line 1 E A 
BILADDR2 7 String*60 Bill-To Address Line 2 E A 
BILADDR3 8 String*60 Bill-To Address Line 3 E A 
BILADDR4 9 String*60 Bill-To Address Line 4 E A 
BILCITY 10 String*30 Bill-To City E A 
BILSTATE 11 String*30 Bill-To State/Province E A 
BILZIP 12 String*20 Bill-To Zip/Postal Code E A 
BILCOUNTRY 13 String*30 Bill-To Country E A 
BILPHONE 14 String*30 Bill-To Phone Number E A  Mask: (%-3C) %-3C-%-24C
BILFAX 15 String*30 Bill-To Fax Number E A  Mask: (%-3C) %-3C-%-24C
BILCONTACT 16 String*60 Bill-To Contact E A 
SHIPTO 17 String*6 Ship-To Location Code E A  Mask: %-6C
SHPNAME 18 String*60 Ship-To Name E A 
SHPADDR1 19 String*60 Ship-To Address Line 1 E A 
SHPADDR2 20 String*60 Ship-To Address Line 2 E A 
SHPADDR3 21 String*60 Ship-To Address Line 3 E A 
SHPADDR4 22 String*60 Ship-To Address Line 4 E A 
SHPCITY 23 String*30 Ship-To City E A 
SHPSTATE 24 String*30 Ship-To State/Province E A 
SHPZIP 25 String*20 Ship-To Zip/Postal Code E A 
SHPCOUNTRY 26 String*30 Ship-To Country E A 
SHPPHONE 27 String*30 Ship-To Phone Number E A  Mask: (%-3C) %-3C-%-24C
SHPFAX 28 String*30 Ship-To Fax Number E A  Mask: (%-3C) %-3C-%-24C
SHPCONTACT 29 String*60 Ship-To Contact E A 
CUSTDISC 30 Integer Customer Discount Level E A  List:6 entries
0 = Base
1 = A
2 = B
3 = C
4 = D
5 = E
PRICELIST 31 String*6 Default Price List Code E A  Mask: %-6N
PONUMBER 32 String*22 Purchase Order Number E A  Mask: %-22C
TERRITORY 33 String*6 Territory E A  Mask: %-6N
TERMS 34 String*6 Terms Code E A  Mask: %-6N
TERMTTLDUE 35 BCD*10.3 Total Terms Amount Due E A C 
DISCAVAIL 36 BCD*10.3 Discount Available E A C 
TERMOVERRD 37 Boolean Terms Rate Override E A C 
REFERENCE 38 String*60 Order Reference E A 
TYPE 39 Integer Order Type E A  List:4 entries
1 = Active
2 = Future
3 = Standing
4 = Quote
ORDDATE 40 Date Order Date E A 
EXPDATE 41 Date Expected Ship Date E A 
QTEXPDATE 42 Date Quote Expiration Date E A 
ORDFISCYR 43 String*4 Order Fiscal Year E A  Mask: %-4d
ORDFISCPER 44 Integer Order Fiscal Period E A P  List:12 entries
1 = 1
2 = 2
3 = 3
4 = 4
5 = 5
6 = 6
7 = 7
8 = 8
9 = 9
10 = 10
11 = 11
12 = 12
SHIPVIA 45 String*6 Ship-Via Code E A  Mask: %-6N
VIADESC 46 String*60 Ship-Via Code Description E A 
LASTINVNUM 47 String*22 Last Invoice Number E A C  Mask: %-22C
NUMINVOICE 48 Integer Number of Invoices E A C 
FOB 49 String*60 Free On Board Point E A 
TEMPLATE 50 String*6 Template Code E A  Mask: %-6N
LOCATION 51 String*6 Default Location Code E A  Mask: %-6N
ONHOLD 52 Boolean On Hold E A  List:2 entries
0 = No
1 = Yes
DESC 53 String*60 Order Description E A 
COMMENT 54 String*250 Order Comment E A 
PRINTSTAT 55 Integer Order Print Status E A C P  List:5 entries
1 =
2 = Quote printed
3 = Picking slip printed
0 = Internet
-1 = Electronic Commerce
LASTPOST 56 Date Last Posting Date E A C 
ORNOPREPAY 57 Integer Order No. of Prepayments E A C 
OVERCREDIT 58 Boolean Over Credit Limit E A C 
APPROVELMT 59 BCD*10.3 Approved Limit A C X 
APPROVEBY 60 String*8 Authorizing User ID E A C  Mask: %-8N
SHIPLABEL 61 Boolean Requires Shipping Labels E A C 
LBLPRINTED 62 Boolean Shipping Labels Printed E A C 
ORHOMECURR 63 String*3 Order Home Currency E A C  Mask: %-3N
ORRATETYPE 64 String*2 Order Rate Type E A X  Mask: %-2N
ORSOURCURR 65 String*3 Order Source Currency E A  Mask: %-3N
ORRATEDATE 66 Date Order Rate Date E A X 
ORRATE 67 BCD*8.7 Order Rate E A X 
ORSPREAD 68 BCD*8.7 Order Spread E A C 
ORDATEMTCH 69 Integer Order Rate Date Matching E A C 
ORRATEREP 70 Integer Order Rate Operator E A C 
ORRATEOVER 71 Boolean Order Rate Override Flag E A C 
ORDTOTAL 72 BCD*10.3 Total Amt. Items E A C 
ORDMTOTAL 73 BCD*10.3 Total Amt. Misc. Charges E A C 
ORDLINES 74 Integer Number of Lines on Order E A C 
NUMLABELS 75 Integer Number of Labels E A 
ORDPAYTOT 76 BCD*10.3 Prev. Payments Total E A C 
ORDPYDSTOT 77 BCD*10.3 Prev. Payment Disc. Total E A C 
SALESPER1 78 String*8 Salesperson 1 E A  Mask: %-8N
SALESPER2 79 String*8 Salesperson 2 E A  Mask: %-8N
SALESPER3 80 String*8 Salesperson 3 E A  Mask: %-8N
SALESPER4 81 String*8 Salesperson 4 E A  Mask: %-8N
SALESPER5 82 String*8 Salesperson 5 E A  Mask: %-8N
SALESPLT1 83 BCD*5.5 Sales Percentage 1 E A 
SALESPLT2 84 BCD*5.5 Sales Percentage 2 E A 
SALESPLT3 85 BCD*5.5 Sales Percentage 3 E A 
SALESPLT4 86 BCD*5.5 Sales Percentage 4 E A 
SALESPLT5 87 BCD*5.5 Sales Percentage 5 E A 
RECALCTAX 88 Boolean Recalculate Tax E A C 
TAXOVERRD 89 Boolean Tax Overridden E A C 
TAXGROUP 90 String*12 Tax Group E A X  Mask: %-12N
TAUTH1 91 String*12 Tax Authority 1 E A  Mask: %-12N
TAUTH2 92 String*12 Tax Authority 2 E A  Mask: %-12N
TAUTH3 93 String*12 Tax Authority 3 E A  Mask: %-12N
TAUTH4 94 String*12 Tax Authority 4 E A  Mask: %-12N
TAUTH5 95 String*12 Tax Authority 5 E A  Mask: %-12N
TCLASS1 96 Integer Tax Class 1 E A X 
TCLASS2 97 Integer Tax Class 2 E A X 
TCLASS3 98 Integer Tax Class 3 E A X 
TCLASS4 99 Integer Tax Class 4 E A X 
TCLASS5 100 Integer Tax Class 5 E A X 
TBASE1 101 BCD*10.3 Tax Base 1 A C X 
TBASE2 102 BCD*10.3 Tax Base 2 A C X 
TBASE3 103 BCD*10.3 Tax Base 3 A C X 
TBASE4 104 BCD*10.3 Tax Base 4 A C X 
TBASE5 105 BCD*10.3 Tax Base 5 A C X 
TEAMOUNT1 106 BCD*10.3 Excluded Tax Amount 1 E A C 
TEAMOUNT2 107 BCD*10.3 Excluded Tax Amount 2 E A C 
TEAMOUNT3 108 BCD*10.3 Excluded Tax Amount 3 E A C 
TEAMOUNT4 109 BCD*10.3 Excluded Tax Amount 4 E A C 
TEAMOUNT5 110 BCD*10.3 Excluded Tax Amount 5 E A C 
TIAMOUNT1 111 BCD*10.3 Included Tax Amount 1 E A C 
TIAMOUNT2 112 BCD*10.3 Included Tax Amount 2 E A C 
TIAMOUNT3 113 BCD*10.3 Included Tax Amount 3 E A C 
TIAMOUNT4 114 BCD*10.3 Included Tax Amount 4 E A C 
TIAMOUNT5 115 BCD*10.3 Included Tax Amount 5 E A C 
TEXEMPT1 116 String*20 Registration 1 E A X 
TEXEMPT2 117 String*20 Registration 2 E A X 
TEXEMPT3 118 String*20 Registration 3 E A X 
TEXEMPT4 119 String*20 Registration 4 E A X 
TEXEMPT5 120 String*20 Registration 5 E A X 
COMPLETE 129 Integer Order Completed E A C  List:5 entries
1 = Incomplete/Not Included
2 = Incomplete/Included
3 = Complete/Not Included
4 = Complete/Included
5 = Complete/Day End
COMPDATE 130 Date Order Completion Date E A C 
INVNUMBER 131 String*22 Invoice Number A X  Mask: %-22C
SHIPDATE 132 Date Shipment Date E A X 
INVDATE 133 Date Invoice Date A X 
INVFISCYR 134 String*4 Invoice Fiscal Year E A  Mask: %-4d
INVFISCPER 135 Integer Invoice Fiscal Period E A P  List:12 entries
1 = 1
2 = 2
3 = 3
4 = 4
5 = 5
6 = 6
7 = 7
8 = 8
9 = 9
10 = 10
11 = 11
12 = 12
NUMPAYMENT 136 BCD*3.0 No. of Terms Payments E A C 
PAYMNTASOF 137 Date Terms Payments As Of Date E A C 
INVWEIGHT 138 BCD*10.4 Order Total Est. Weight E A C 
NEXTDTLNUM 139 Integer Next Detail Number E A C 
POSTINV 140 Boolean Post Invoice E A 
IDISONMISC 141 Boolean Invoice Disc. Misc. Charges E A 
INNOPREPAY 142 Integer Invoice No. of Prepayments E A C 
NOSHIPLINE 143 Integer No. Lines Qty. Shipped E A C 
NOMISCLINE 144 Integer No. Misc. Charges Lines E A C 
INVNETNOTX 145 BCD*10.3 Order Total Before Tax E A C 
INVITAXTOT 146 BCD*10.3 Order Incl. Tax Total E A C 
INVITMTOT 147 BCD*10.3 Order Item Total Amount E A C 
INVDISCBAS 148 BCD*10.3 Order Discount Base E A C 
INVDISCPER 149 BCD*5.5 Order Discount Percentage E A 
INVDISCAMT 150 BCD*10.3 Order Discount Amount E A 
INVMISC 151 BCD*10.3 Order Total Misc. Charges E A C 
INVSUBTOT 152 BCD*10.3 Order Subtotal Amount E A C 
INVNET 153 BCD*10.3 Order Total With Inv. Disc. E A C 
INVETAXTOT 154 BCD*10.3 Order Excl. Tax Total E A C 
INVNETWTX 155 BCD*10.3 Order Total E A C 
INVAMTDUE 156 BCD*10.3 Order Amount Due E A C 
INHOMECURR 157 String*3 Order Home Currency E A C  Mask: %-3N
INRATETYPE 158 String*2 Order Rate Type E A X  Mask: %-2N
INSOURCURR 159 String*3 Order Source Currency E A C  Mask: %-3N
INRATEDATE 160 Date Order Rate Date E A X 
INRATE 161 BCD*8.7 Order Rate E A X 
INSPREAD 162 BCD*8.7 Order Spread E A C 
INDATEMTCH 163 Integer Order Rate Date Matching E A C 
INRATEREP 164 Integer Order Rate Operator E A C 
INRATEOVER 165 Boolean Order Rate Override Flag E A C 
REBATCHNUM 166 BCD*5.0 Receipt Batch Number E A 
BANKCODE 167 String*8 Bank Code E A  Mask: %-8N
BANKRECTYP 168 String*12 Receipt Type E A  Mask: %-12C
CHECKDATE 169 Date Check Date E A 
CHKFISCYR 170 String*4 Check Fiscal Year E A  Mask: %-4d
CHKFISCPER 171 Integer Check Fiscal Period E A P  List:12 entries
1 = 1
2 = 2
3 = 3
4 = 4
5 = 5
6 = 6
7 = 7
8 = 8
9 = 9
10 = 10
11 = 11
12 = 12
CHECKNUM 172 String*24 Check Number E A 
APPLYTO 173 Integer Payment Applied To E A  List:3 entries
2 = Invoice No.
4 = Order No.
9 = Shipment No.
PAYMENT 174 BCD*10.3 Payment In Cust. Currency E A 
INVPAYDISC 175 BCD*10.3 Invoice Total Terms Disc. E A 
BANKPAYMNT 176 BCD*10.3 Payment In Bank Currency E A 
PAHOMECURR 177 String*3 Payment Home Currency E A  Mask: %-3N
PARATETYPE 178 String*2 Payment Rate Type E A  Mask: %-2N
PASOURCURR 179 String*3 Payment Source Currency E A  Mask: %-3N
PARATEDATE 180 Date Payment Rate Date E A 
PARATE 181 BCD*8.7 Payment Rate E A 
PASPREAD 182 BCD*8.7 Payment Spread E A 
PADATEMTCH 183 Integer Payment Rate Date Matching E A 
PARATEREP 184 Integer Payment Rate Operator E A 
PCODDESC 185 String*60 Price List Code Desc. E A 
TERMDESC 186 String*60 Terms Code Description E A 
TXGRPDESC 187 String*60 Tax Group Code Desc. E A 
LOCDESC 188 String*60 Location Code Desc. E A 
SALES1NAME 189 String*60 Salesperson Name 1 E A C 
SALES2NAME 190 String*60 Salesperson Name 2 E A C 
SALES3NAME 191 String*60 Salesperson Name 3 E A C 
SALES4NAME 192 String*60 Salesperson Name 4 E A C 
SALES5NAME 193 String*60 Salesperson Name 5 E A C 
TAUTH1DESC 194 String*60 Tax Authority 1 Desc. E A C 
TAUTH2DESC 195 String*60 Tax Authority 2 Desc. E A C 
TAUTH3DESC 196 String*60 Tax Authority 3 Desc. E A C 
TAUTH4DESC 197 String*60 Tax Authority 4 Desc. E A C 
TAUTH5DESC 198 String*60 Tax Authority 5 Desc. E A C 
TCLAS1DESC 199 String*60 Tax Class 1 Description E A C 
TCLAS2DESC 200 String*60 Tax Class 2 Description E A C 
TCLAS3DESC 201 String*60 Tax Class 3 Description E A C 
TCLAS4DESC 202 String*60 Tax Class 4 Description E A C 
TCLAS5DESC 203 String*60 Tax Class 5 Description E A C 
ORSRCDESC 204 String*60 Order Source Currency Desc. E A 
ORHOMDESC 205 String*60 Order Home Currency Desc. E A 
ORRTTYDESC 206 String*60 Order Rate Type Description E A 
INSRCDESC 207 String*60 Invoice Source Curr. Desc. E A 
INHOMDESC 208 String*60 Invoice Home Currency Desc. E A 
INRTTYDESC 209 String*60 Invoice Rate Type Desc. E A 
PASRCDESC 210 String*60 Payment Source Curr. Desc. E A 
PAHOMDESC 211 String*60 Payment Home Currency Desc. E A 
PARTTYDESC 212 String*60 Payment Rate Type Desc. E A 
TAMOUNT1 213 BCD*10.3 Total Tax Amount 1 A C X 
TAMOUNT2 214 BCD*10.3 Total Tax Amount 2 A C X 
TAMOUNT3 215 BCD*10.3 Total Tax Amount 3 A C X 
TAMOUNT4 216 BCD*10.3 Total Tax Amount 4 A C X 
TAMOUNT5 217 BCD*10.3 Total Tax Amount 5 A C X 
INVTAXTOT 218 BCD*10.3 Total Tax Amount E A 
APPPASSWRD 219 String*64 Authorizing User Password E A X 
RUNNINGTOT 220 BCD*10.3 Order Running Total E A 
ORDPAYMENT 221 BCD*10.3 Order Total Payment E A 
ORDPAYDISC 222 BCD*10.3 Order Total Payment Disc. E A 
AMTDUENODS 223 BCD*10.3 Amount Due Less Curr. Prepayment E A 
GOCALCTAX 224 Boolean Perform Tax Calculation E A 
GOCHKCRDT 225 Boolean Perform Credit Limit Check E A 
ORDERSOURC 226 Integer Order Source E A C  List:4 entries
0 = Entered
1 = Internet
2 = Electronic Commerce
3 = ePOS
GOSHIPALL 227 Boolean Perform Ship All E A 
DOSCONVERT 228 Boolean DOS Conversion in Progress E A  List:2 entries
0 = No
1 = Yes
GOFCALCTAX 229 Boolean Perform Forced Tax Calculation E A 
GODISTTAX 230 Boolean Perform Manual Tax Distribution E A 
TXCALCINPG 231 Boolean Tax Calculation in Progress E A C 
AUTOTAXCAL 232 Boolean Auto-Tax Calculation Status E A X 
QUONUMBER 243 String*22 Originating Quote Number E A  Mask: %-22C
RTWARNMSG 244 Boolean Display Rate Warning E A 
CUSTEXIST 245 Boolean Customer Exists E A 
INVPRODUCE 246 Boolean Invoice Will Be Produced A X 
SECENABLED 247 Boolean Security Enabled E A 
GOAPPROSEC 248 Boolean User Can Approve Credit Lift E A 
GOCALCPYDT 249 Boolean Recalc. Multi-Payment Dates E A 
BILEMAIL 250 String*50 Bill-To E-mail E A 
BILPHONEC 251 String*30 Bill-To Contact Phone E A  Mask: (%-3C) %-3C-%-24C
BILFAXC 252 String*30 Bill-To Contact Fax E A  Mask: (%-3C) %-3C-%-24C
BILEMAILC 253 String*50 Bill-To Contact E-mail E A 
SHPEMAIL 254 String*50 Ship-To E-mail E A 
SHPPHONEC 255 String*30 Ship-To Contact Phone E A  Mask: (%-3C) %-3C-%-24C
SHPFAXC 256 String*30 Ship-To Contact Fax E A  Mask: (%-3C) %-3C-%-24C
SHPEMAILC 257 String*50 Ship-To Contact E-mail E A 
SWPARTSHIP 258 Integer Allow partial shipments E A C  List:2 entries
0 = No
1 = Yes
MULTIQUO 259 Boolean Multiple Quotes E A  List:2 entries
0 = No
1 = Yes
QUOS 260 Integer Number of Quotes E A C 
GOQUOTOORD 261 Boolean Perform Multiple Quotes to Order E A 
LASTSHINUM 262 String*22 Last Shipment Number E A C  Mask: %-22C
NUMSHPMENT 263 Integer Number of Shipments E A 
SHIPTRACK 264 String*36 Shipment Tracking Number E A 
POSTSEQNUM 266 Long Post Sequence Number A C 
SHIUNIQ 267 BCD*10.0 Shipment Uniquifier E A 
SHINUMBER 268 String*22 Shipment Number A X  Mask: %-22C
SHIDATE 269 Date Shipment Date A X 
SHHOMECURR 270 String*3 Shipment Home Currency E A C  Mask: %-3N
SHRATETYPE 271 String*2 Shipment Rate Type E A X  Mask: %-2N
SHSOURCURR 272 String*3 Shipment Source Currency E A C  Mask: %-3N
SHRATEDATE 273 Date Shipment Rate Date E A X 
SHRATE 274 BCD*8.7 Shipment Rate E A X 
SHSPREAD 275 BCD*8.7 Shipment Spread E A C 
SHDATEMTCH 276 Integer Shipment Date Match E A C 
SHRATEREP 277 Integer Shipment Rate Operator E A C 
SHRATEOVER 278 Boolean Shipment Rate Override Flag E A C 
SHSRCDESC 279 String*60 Shipment Source Currency Desc. E A 
SHHOMDESC 280 String*60 Shipment Home Currency Desc. E A 
SHRTTYDESC 281 String*60 Shipment Rate Type Description E A 
GOCHKPSHIP 282 Boolean Order Partially Shipped E A 
SHINETWTX 283 BCD*10.3 Shipment Total E A 
VALUES 284 Long Optional Fields E A C 
FRMUNIQ 285 BCD*10.0 Predecessor Uniquifier E A 
FRMNUMBER 286 String*22 Predecessor Number E A  Mask: %-22C
PROCESSCMD 287 Integer Process OIP Command E A C  List:17 entries
0 = Nothing to Process
1 = Insert Optional Fields
2 = Default and Tranfer Optional Fields
3 = Default Opt. Fields During Record Generation
4 = Remove Optional Fields
5 = Transfer Opt. Fields from Standing Document
21 = Auto-generate Serials
22 = Auto-generate Lots
23 = Auto-allocate Serials
24 = Auto-allocate Lots
25 = Clear Serials
26 = Clear Lots
27 = Auto-assign Serials
28 = Auto-assign Lots
29 = Create List of Existing Serials/Lots
31 = Post Serials/Lots to IC Inventory
32 = Verify Serials/Lots
OECOMMAND 288 Integer Process O/E Command E A C  List:28 entries
0 = No Action
1 = Calculate Tax
2 = Force Calculate Tax
3 = Distribute Manual Tax
4 = Check Customer Credit Limit
5 = Pre-Check Customer Credit Limit
6 = Validate Credit Check Approval Authority
7 = Validate Credit Pre-Check Approval Authority
8 = Ship All
9 = Recalculate Payment Schedule Dates
10 = Check Partial Shipment
11 = Create Order From Quotes
16 = Derive Tax Reporting Rate
18 = Calculate Shipment Amount Due
19 = Check Job Related Quote Details
20 = Validate Job-Related Prepayment
21 = Distribute Prepayment to Job Details
23 = Create Sage CRM Address
24 = Set lock for Credit Card Transaction
25 = Find Incomplete Shipment for a Given Order
26 = Set lock for editing a document that has been pre-authorized.
27 = Confirm Web Credit Approval
28 = Confirm Web Credit Pre-Check Approval
29 = Pre-authorize
30 = Pre-Authorize CNA2 Part 1
31 = Pre-Authorize CNA2 Part 2
32 = Update Location from Header
33 = Update Ship Date from Header
EDAPRVLMT 289 BCD*10.3 User-Entered Approval Amount E A C 
SWCHKLIMC 290 Boolean Checking Customer Credit Limit E A C 
SWCHKODUEC 291 Boolean Checking Customer Aging Limit E A C 
SWCHKLIMA 292 Boolean Checking Nat. Acct. Credit Limit E A C 
SWCHKODUEA 293 Boolean Checking Nat. Acct. Aging Limit E A C 
SWOVERLIMC 294 Boolean Customer Is Over Credit Limit E A C 
SWOVERDUEC 295 Boolean Customer Is Over Aging Limit E A C 
SWOVERLIMA 296 Boolean Nat. Acct. Is Over Credit Limit E A C 
SWOVERDUEA 297 Boolean Nat. Acct. Is Over Aging Limit E A C 
AMTLIMITC 298 BCD*10.3 Customer Credit Limit E A C 
AMTBALCUST 299 BCD*10.3 Customer Balance (Posted) E A C 
OVDUEDAYSC 300 Integer Customer Days Overdue E A C 
OVDUELMTC 301 BCD*10.3 Customer Overdue Limit E A C 
OVDUEBALC 302 BCD*10.3 Customer Balance Overdue E A C 
AMTLIMITA 303 BCD*10.3 Nat. Acct. Credit Limit E A C 
AMTBALACCT 304 BCD*10.3 Nat. Acct. Balance E A C 
OVDUEDAYSA 305 Integer Nat. Acct. Days Overdue E A C 
OVDUELMTA 306 BCD*10.3 Nat. Acct. Overdue Limit E A C 
OVDUEBALA 307 BCD*10.3 Nat. Acct. Balance Overdue E A C 
SWARPEND 308 Boolean A/R Pending Trans. Included E A C 
SWOEPEND 309 Boolean O/E Pending Trans. Included E A C 
SWXXPEND 310 Boolean Other Pending Trans. Included E A C 
AMTARPEND 311 BCD*10.3 A/R Pending Balance E A C 
AMTOEPEND 312 BCD*10.3 O/E Pending Balance E A C 
AMTXXPEND 313 BCD*10.3 Other Pending Balance E A C 
AMTTOTCUST 314 BCD*10.3 Customer Total Outstanding E A C 
AMTTOTACCT 315 BCD*10.3 Nat. Acct. Total Outstanding E A C 
AMTLEFTC 316 BCD*10.3 Customer Limit Left E A C 
AMTLEFTA 317 BCD*10.3 Nat. Acct. Limit Left E A C 
AMTOVERC 318 BCD*10.3 Customer Limit Exceeded E A C 
AMTOVERA 319 BCD*10.3 Nat. Acct. Limit Exceeded E A C 
AMTLASTIVT 320 BCD*10.3 Last Invoice Amount E A C 
DATELASTIV 321 Date Last Invoice Date E A C 
AMTLASTPYT 322 BCD*10.3 Last Payment Amount E A C 
DATELASTPA 323 Date Last Payment Date E A C 
DRIVENBYUI 324 Boolean Driven by UI E A 
ITEMDISTOT 325 BCD*10.3 Item Detail Discount Total E A C 
MISCDISTOT 326 BCD*10.3 Misc. Charge Detail Discount Total E A C 
DTLDISCTOT 327 BCD*10.3 Detail Discount Total E A C 
DTLDISCPER 328 BCD*5.5 Detail Discount Percentage E A C 
INVNTDTDIS 329 BCD*10.3 Document Net of Detail Disc. E A C 
OTRMETHOD 330 Integer Auto-Calc. Tax Reporting Amounts E A X 
OTRCURRNCY 331 String*3 Tax Reporting (TR) Currency E A C  Mask: %-3N
OTRRATTYPE 332 String*2 TR Rate Type E A X  Mask: %-2N
OTRRATDATE 333 Date TR Rate Date E A X 
OTRRATE 334 BCD*8.7 TR Rate E A X 
OTRSPREAD 335 BCD*8.7 TR Spread E A C 
OTRDATMTCH 336 Integer TR Rate Date Matching E A C 
OTRRATEOP 337 Integer TR Rate Operator E A C 
OTRRATOVER 338 Boolean TR Rate Override Flag E A C 
OTREAMNT1 339 BCD*10.3 TR Excluded Tax Amount 1 E A C 
OTREAMNT2 340 BCD*10.3 TR Excluded Tax Amount 2 E A C 
OTREAMNT3 341 BCD*10.3 TR Excluded Tax Amount 3 E A C 
OTREAMNT4 342 BCD*10.3 TR Excluded Tax Amount 4 E A C 
OTREAMNT5 343 BCD*10.3 TR Excluded Tax Amount 5 E A C 
OTRIAMNT1 344 BCD*10.3 TR Included Tax Amount 1 E A C 
OTRIAMNT2 345 BCD*10.3 TR Included Tax Amount 2 E A C 
OTRIAMNT3 346 BCD*10.3 TR Included Tax Amount 3 E A C 
OTRIAMNT4 347 BCD*10.3 TR Included Tax Amount 4 E A C 
OTRIAMNT5 348 BCD*10.3 TR Included Tax Amount 5 E A C 
OTRAMOUNT1 349 BCD*10.3 TR Tax Amount 1 A C X 
OTRAMOUNT2 350 BCD*10.3 TR Tax Amount 2 A C X 
OTRAMOUNT3 351 BCD*10.3 TR Tax Amount 3 A C X 
OTRAMOUNT4 352 BCD*10.3 TR Tax Amount 4 A C X 
OTRAMOUNT5 353 BCD*10.3 TR Tax Amount 5 A C X 
OTRETOTAL 354 BCD*10.3 TR Excluded Tax Total E A C 
OTRITOTAL 355 BCD*10.3 TR Included Tax Total E A C 
OTRTOTAL 356 BCD*10.3 TR Tax Total E A C 
STRCURRNCY 357 String*3 Tax Reporting Shipment (TR) Currency E A C  Mask: %-3N
STRRATTYPE 358 String*2 TR Shipment Rate Type E A X  Mask: %-2N
STRRATDATE 359 Date TR Shipment Rate Date E A X 
STRRATE 360 BCD*8.7 TR Shipment Rate E A X 
STRSPREAD 361 BCD*8.7 TR Shipment Spread E A C 
STRDATMTCH 362 Integer TR Shipment Rate Date Matching E A C 
STRRATEOP 363 Integer TR Shipment Rate Operator E A C 
STRRATOVER 364 Boolean TR Shipment Rate Override Flag E A C 
ITRCURRNCY 365 String*3 Tax Reporting Invoice (TR) Currency E A C  Mask: %-3N
ITRRATTYPE 366 String*2 TR Invoice Rate Type E A X  Mask: %-2N
ITRRATDATE 367 Date TR Invoice Rate Date E A X 
ITRRATE 368 BCD*8.7 TR Invoice Rate E A X 
ITRSPREAD 369 BCD*8.7 TR Invoice Spread E A C 
ITRDATMTCH 370 Integer TR Invoice Rate Date Matching E A C 
ITRRATEOP 371 Integer TR Invoice Rate Operator E A C 
ITRRATOVER 372 Boolean TR Invoice Rate Override Flag E A C 
OTRCURDESC 373 String*60 TR Currency Description E A 
STRCURDESC 374 String*60 TR Shipment Currency Description E A 
ITRCURDESC 375 String*60 TR Invoice Currency Description E A 
OTRRTYDESC 376 String*60 TR Rate Type Description E A 
STRRTYDESC 377 String*60 TR Shipment Rate Type Description E A 
ITRRTYDESC 378 String*60 TR Invoice Rate Type Description E A 
PAYMTYPE 379 Integer Payment Type E A  List:6 entries
0 = (None)
1 = Cash
2 = Check
3 = Credit Card
4 = Other
5 = SPS Credit Card
PENDPREPAY 384 BCD*10.3 Pending Prepayment Amount E A 
DISAMTOVER 385 Boolean Order Discount Amount Override E A C 
HASJOB 386 Boolean Job Related A X  List:2 entries
0 = No
1 = Yes
JOBLINES 387 Long Job Related Detail Lines E A C 
NONINVABLE 388 Boolean Project Invoicing A X  List:2 entries
0 = No
1 = Yes
LNINVABLE 389 Long Invoiceable Detail Lines E A C 
HASRTG 390 Boolean Has Retainage A X  List:2 entries
0 = No
1 = Yes
RTGTERMS 391 String*6 Retainage Terms A X  Mask: %-6N
RTGRATE 392 Integer Retainage Exchange Rate A X  List:2 entries
0 = Use Original Document Exchange Rate
1 = Use Current Exchange Rate
RTGTERMDSC 393 String*60 Retainage Terms Description A 
CUSACCTSET 394 String*6 Customer Account Set E A  Mask: %-6N
CUSACTDESC 395 String*60 Customer Account Set Description E A C 
ENTEREDBY 396 String*8 Entered By E A  Mask: %-8N
PFSEGLEN 397 Integer ePOS Segment Length E A 
SHIDATEBUS 398 Date Shipment Posting Date E A 
INVDATEBUS 399 Date Invoice Posting Date E A 
PAYDISTTOT 400 BCD*10.3 Prepayment Distributed Amount E A C 
UNAPPLDPAY 401 BCD*10.3 Prepayment Unapplied Amount E A C 
COMPANYID 402 Long Sage CRM Company ID E A 
OPPOID 403 Long Sage CRM Opportunity ID E A 
PERSONID 404 Long Sage CRM Person ID E A 
INCOPPOTOT 405 Boolean Include In CRM Opportunity Total E A 
QTEXPIRED 406 Boolean Quote Expired E A C  List:2 entries
0 = No
1 = Yes
QUOORDUNIQ 407 BCD*10.0 Order Uniq. Activated From Quote E A 
QUOORDNUM 408 String*22 Order Number Activated From Quote E A  Mask: %-22C
CUSTPROMOT 409 String*12 Promoted Customer Number E A C  Mask: %-12C
PAYMONORD 410 Integer Payment Type On Order E A  List:6 entries
0 = (None)
1 = Cash
2 = Check
3 = Credit Card
4 = Other
5 = SPS Credit Card
PAYMCODE 411 String*12 Payment Code On Order E A 
IDCARD 412 String*12 Payment Card ID E A 
HASPREAUTH 413 Boolean Order Has PreAuthorization E A C  List:2 entries
0 = No
1 = Yes
HOLDREASON 414 String*60 On-hold Reason E A 
INCOMPSHIP 415 Boolean Incomplete Ship. Exist for Order E A C  List:2 entries
0 = No
1 = Yes
REQUESDATE 416 Date Date Requested E A 
TRANSID 417 String*36 Transaction ID E A 
XMLSTRING 418 String*20000 XML String E A 
RESPIND 419 String*1 Response Indicator E A 
RESPCD 420 String*6 Response Code E A 
RESPMSG 421 String*32 Response Message E A 
AUTHCODE 422 String*6 Authorization Code E A 
AVSRESULT 423 String*1 AVSResult E A 
CVVRESULT 424 String*1 CVVResult E A 
TRANSDATE 425 String*22 Transaction Date E A 
VANREF 426 String*16 VANReference E A 
LAST4 427 String*16 Last 4 E A 
PMTDESC 428 String*30 Payment Description E A 
PMTTYPEID 429 String*1 Payment Type ID E A 

This page was generated on 2021-Nov-24

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).