View: Orders

RotoID: OE0520
Tables: OEORDHOEORDH1
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 TYPECOMPLETEORDUNIQ
Customer/Order CUSTOMERORDNUMBER
Reference/Order REFERENCEORDNUMBER
Customer/PO No. CUSTOMERPONUMBER
Customer/OnHold/Type CUSTOMERONHOLDTYPE
Sage CRM Opportunity COMPANYIDOPPOID

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 C  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