# 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: 8

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

## Fields: 382

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: %-30c
BILFAX | 15 | String*30 | Bill-To Fax Number | E A | Mask: %-30c
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: %-30c
SHPFAX | 28 | String*30 | Ship-To Fax Number | E A | Mask: %-30c
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 |
SALES2NAME | 190 | String*60 | Salesperson Name 2 | E A |
SALES3NAME | 191 | String*60 | Salesperson Name 3 | E A |
SALES4NAME | 192 | String*60 | Salesperson Name 4 | E A |
SALES5NAME | 193 | String*60 | Salesperson Name 5 | E A |
TAUTH1DESC | 194 | String*60 | Tax Authority 1 Desc. | E A |
TAUTH2DESC | 195 | String*60 | Tax Authority 2 Desc. | E A |
TAUTH3DESC | 196 | String*60 | Tax Authority 3 Desc. | E A |
TAUTH4DESC | 197 | String*60 | Tax Authority 4 Desc. | E A |
TAUTH5DESC | 198 | String*60 | Tax Authority 5 Desc. | E A |
TCLAS1DESC | 199 | String*60 | Tax Class 1 Description | E A |
TCLAS2DESC | 200 | String*60 | Tax Class 2 Description | E A |
TCLAS3DESC | 201 | String*60 | Tax Class 3 Description | E A |
TCLAS4DESC | 202 | String*60 | Tax Class 4 Description | E A |
TCLAS5DESC | 203 | String*60 | Tax Class 5 Description | E A |
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: %-30c
BILFAXC | 252 | String*30 | Bill-To Contact Fax | E A | Mask: %-30c
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: %-30c
SHPFAXC | 256 | String*30 | Ship-To Contact Fax | E A | Mask: %-30c
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: 17 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
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: 5 entries
0 | = | (None)
1 | = | Cash
2 | = | Check
3 | = | Credit Card
4 | = | Other
CCTYPE | 380 | String*12 | Credit Card Type | E A | Mask: %-12N
CCNUMBER | 381 | Binary*32 | Credit Card Number | E A |
CCNAME | 382 | String*60 | Credit Card Name | E A |
CCAUTHCODE | 383 | String*20 | Authorization Code | E A |
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 |
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 |

This page was generated on 2009-Nov-19

Copyright © 2001–2009 Sage Software, Inc. All rights reserved.