| ORDUNIQ |
BCD*10.0 |
Order Uniquifier |
|
| AUDTDATE |
Date |
|
|
| AUDTTIME |
Time |
|
|
| AUDTUSER |
String*8 |
|
|
| AUDTORG |
String*6 |
|
|
| ORDNUMBER |
String*22 |
Order Number |
Mask: %-22C |
| CUSTOMER |
String*12 |
Customer Number |
Mask: %-12C |
| CUSTGROUP |
String*3 |
Customer Group Code |
Mask: %-3C |
| BILNAME |
String*30 |
Bill-To Name |
|
| BILADDR1 |
String*30 |
Bill-To Address Line 1 |
|
| BILADDR2 |
String*30 |
Bill-To Address Line 2 |
|
| BILADDR3 |
String*30 |
Bill-To Address Line 3 |
|
| BILADDR4 |
String*30 |
Bill-To Address Line 4 |
|
| BILCITY |
String*20 |
Bill-To City |
|
| BILSTATE |
String*20 |
Bill-To State/Province |
|
| BILZIP |
String*15 |
Bill-To Zip/Postal Code |
|
| BILCOUNTRY |
String*20 |
Bill-To Country |
|
| BILPHONE |
String*20 |
Bill-To Phone Number |
Mask: (%-3C) %-3C-%-10C |
| BILFAX |
String*20 |
Bill-To Fax Number |
Mask: (%-3C) %-3C-%-10C |
| BILCONTACT |
String*30 |
Bill-To Contact |
|
| SHIPTO |
String*6 |
Ship-To Location Code |
Mask: %-6C |
| SHPNAME |
String*30 |
Ship-To Name |
|
| SHPADDR1 |
String*30 |
Ship-To Address Line 1 |
|
| SHPADDR2 |
String*30 |
Ship-To Address Line 2 |
|
| SHPADDR3 |
String*30 |
Ship-To Address Line 3 |
|
| SHPADDR4 |
String*30 |
Ship-To Address Line 4 |
|
| SHPCITY |
String*20 |
Ship-To City |
|
| SHPSTATE |
String*20 |
Ship-To State/Province |
|
| SHPZIP |
String*15 |
Ship-To Zip/Postal Code |
|
| SHPCOUNTRY |
String*20 |
Ship-To Country |
|
| SHPPHONE |
String*20 |
Ship-To Phone Number |
Mask: (%-3C) %-3C-%-10C |
| SHPFAX |
String*20 |
Ship-To Fax Number |
Mask: (%-3C) %-3C-%-10C |
| SHPCONTACT |
String*30 |
Ship-To Contact |
|
| CUSTDISC |
Integer |
Customer Discount Level |
List: 6 entries
|
| PRICELIST |
String*6 |
Default Price List Code |
Mask: %-6N |
| PONUMBER |
String*22 |
Purchase Order Number |
Mask: %-22C |
| TERRITORY |
String*2 |
Territory |
Mask: %-2N |
| TERMS |
String*6 |
Terms Code |
Mask: %-6N |
| TERMTTLDUE |
BCD*10.3 |
Total Terms Amount Due |
|
| DISCAVAIL |
BCD*10.3 |
Discount Available |
|
| TERMOVERRD |
Boolean |
Terms Rate Override |
|
| REFERENCE |
String*22 |
Order Reference |
|
| TYPE |
Integer |
Order Type |
List: 4 entries
| 1 | = | Active | | 2 | = | Future | | 3 | = | Standing | | 4 | = | Quote |
|
| ORDDATE |
Date |
Order Date |
|
| EXPDATE |
Date |
Expected Ship Date |
|
| QTEXPDATE |
Date |
Quote Expiration Date |
|
| ORDFISCYR |
String*4 |
Order Fiscal Year |
Mask: %-4d |
| ORDFISCPER |
Integer |
Order Fiscal Period |
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 |
String*6 |
Ship-Via Code |
Mask: %-6N |
| VIADESC |
String*30 |
Ship-Via Code Description |
|
| LASTINVNUM |
String*15 |
Last Invoice Number |
Mask: %-15C |
| NUMINVOICE |
Integer |
Number of Invoices |
|
| FOB |
String*30 |
Free On Board Point |
|
| TEMPLATE |
String*6 |
Template Code |
Mask: %-6N |
| LOCATION |
String*6 |
Default Location Code |
Mask: %-6N |
| ONHOLD |
Boolean |
On Hold Status |
List: 2 entries
|
| DESC |
String*30 |
Order Description |
|
| COMMENT |
String*250 |
Order Comment |
|
| PRINTSTAT |
Integer |
Order Print Status |
List: 5 entries
| 1 | = | | | 2 | = | Quote printed | | 3 | = | Picking slip printed | | 0 | = | Internet | | -1 | = | Electronic Commerce |
|
| LASTPOST |
Date |
Last Posting Date |
|
| ORNOPREPAY |
Integer |
Order No. of Prepayments |
|
| OVERCREDIT |
Boolean |
Over Credit Limit |
|
| APPROVELMT |
BCD*10.3 |
Approved Limit |
|
| APPROVEBY |
String*8 |
Authorizing User ID |
Mask: %-8N |
| SHIPLABEL |
Boolean |
Requires Shipping Labels |
|
| LBLPRINTED |
Boolean |
Shipping Labels Printed |
|
| ORHOMECURR |
String*3 |
Order Home Currency |
Mask: %-3N |
| ORRATETYPE |
String*2 |
Order Rate Type |
Mask: %-2N |
| ORSOURCURR |
String*3 |
Order Source Currency |
Mask: %-3N |
| ORRATEDATE |
Date |
Order Rate Date |
|
| ORRATE |
BCD*8.7 |
Order Rate |
|
| ORSPREAD |
BCD*8.7 |
Order Spread |
|
| ORDATEMTCH |
Integer |
Order Rate Date Matching |
|
| ORRATEREP |
Integer |
Order Rate Representation |
|
| ORRATEOVER |
Boolean |
Order Rate Override Flag |
|
| ORDTOTAL |
BCD*10.3 |
Total Amt. Items |
|
| ORDMTOTAL |
BCD*10.3 |
Total Amt. Misc. Charges |
|
| ORDLINES |
Integer |
Number of Lines on Order |
|
| NUMLABELS |
Integer |
Number of Labels |
|
| ORDPAYTOT |
BCD*10.3 |
Prev. Payments Total |
|
| ORDPYDSTOT |
BCD*10.3 |
Prev. Payment Disc. Total |
|
| SALESPER1 |
String*8 |
Salesperson 1 |
Mask: %-8N |
| SALESPER2 |
String*8 |
Salesperson 2 |
Mask: %-8N |
| SALESPER3 |
String*8 |
Salesperson 3 |
Mask: %-8N |
| SALESPER4 |
String*8 |
Salesperson 4 |
Mask: %-8N |
| SALESPER5 |
String*8 |
Salesperson 5 |
Mask: %-8N |
| SALESPLT1 |
BCD*5.5 |
Sales Percentage 1 |
|
| SALESPLT2 |
BCD*5.5 |
Sales Percentage 2 |
|
| SALESPLT3 |
BCD*5.5 |
Sales Percentage 3 |
|
| SALESPLT4 |
BCD*5.5 |
Sales Percentage 4 |
|
| SALESPLT5 |
BCD*5.5 |
Sales Percentage 5 |
|
| RECALCTAX |
Boolean |
Recalculate Tax |
|
| TAXOVERRD |
Boolean |
Tax Overridden |
|
| TAXGROUP |
String*6 |
Tax Group |
Mask: %-6N |
| TAUTH1 |
String*6 |
Tax Authority 1 |
Mask: %-6N |
| TAUTH2 |
String*6 |
Tax Authority 2 |
Mask: %-6N |
| TAUTH3 |
String*6 |
Tax Authority 3 |
Mask: %-6N |
| TAUTH4 |
String*6 |
Tax Authority 4 |
Mask: %-6N |
| TAUTH5 |
String*6 |
Tax Authority 5 |
Mask: %-6N |
| TCLASS1 |
Integer |
Tax Class 1 |
|
| TCLASS2 |
Integer |
Tax Class 2 |
|
| TCLASS3 |
Integer |
Tax Class 3 |
|
| TCLASS4 |
Integer |
Tax Class 4 |
|
| TCLASS5 |
Integer |
Tax Class 5 |
|
| TBASE1 |
BCD*10.3 |
Tax Base 1 |
|
| TBASE2 |
BCD*10.3 |
Tax Base 2 |
|
| TBASE3 |
BCD*10.3 |
Tax Base 3 |
|
| TBASE4 |
BCD*10.3 |
Tax Base 4 |
|
| TBASE5 |
BCD*10.3 |
Tax Base 5 |
|
| TEAMOUNT1 |
BCD*10.3 |
Excluded Tax Amount 1 |
|
| TEAMOUNT2 |
BCD*10.3 |
Excluded Tax Amount 2 |
|
| TEAMOUNT3 |
BCD*10.3 |
Excluded Tax Amount 3 |
|
| TEAMOUNT4 |
BCD*10.3 |
Excluded Tax Amount 4 |
|
| TEAMOUNT5 |
BCD*10.3 |
Excluded Tax Amount 5 |
|
| TIAMOUNT1 |
BCD*10.3 |
Included Tax Amount 1 |
|
| TIAMOUNT2 |
BCD*10.3 |
Included Tax Amount 2 |
|
| TIAMOUNT3 |
BCD*10.3 |
Included Tax Amount 3 |
|
| TIAMOUNT4 |
BCD*10.3 |
Included Tax Amount 4 |
|
| TIAMOUNT5 |
BCD*10.3 |
Included Tax Amount 5 |
|
| TEXEMPT1 |
String*20 |
Registration 1 |
|
| TEXEMPT2 |
String*20 |
Registration 2 |
|
| TEXEMPT3 |
String*20 |
Registration 3 |
|
| TEXEMPT4 |
String*20 |
Registration 4 |
|
| TEXEMPT5 |
String*20 |
Registration 5 |
|
| OPTIONAL1 |
String*2 |
Optional Field 1 |
Mask: %-2c |
| OPTIONAL2 |
String*3 |
Optional Field 2 |
Mask: %-3N |
| OPTIONAL3 |
String*4 |
Optional Field 3 |
Mask: %-4c |
| OPTIONAL4 |
String*12 |
Optional Field 4 |
Mask: %-12c |
| OPTIONAL5 |
String*15 |
Optional Field 5 |
Mask: %-15c |
| OPTIONAL6 |
String*30 |
Optional Field 6 |
Mask: %-30c |
| OPTDATE |
Date |
Optional Date Field |
|
| OPTAMT |
BCD*10.3 |
Optional Amount Field |
|
| COMPLETE |
Integer |
Order Completed |
List: 5 entries
| 1 | = | Incomplete/Not Included | | 2 | = | Incomplete/Included | | 3 | = | Complete/Not Included | | 4 | = | Complete/Included | | 5 | = | Complete/Day End |
|
| COMPDATE |
Date |
Order Completion Date |
|
| INVNUMBER |
String*15 |
Invoice Number |
Mask: %-15C |
| SHIPDATE |
Date |
Shipment Date |
|
| INVDATE |
Date |
Invoice Date |
|
| INVFISCYR |
String*4 |
Invoice Fiscal Year |
Mask: %-4d |
| INVFISCPER |
Integer |
Invoice Fiscal Period |
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 |
BCD*3.0 |
No. of Terms Payments |
|
| PAYMNTASOF |
Date |
Terms Payments As Of Date |
|
| INVWEIGHT |
BCD*10.4 |
Invoice Total Est. Weight |
|
| NEXTDTLNUM |
Integer |
Next Detail Number |
|
| POSTINV |
Boolean |
Post Invoice |
|
| IDISONMISC |
Boolean |
Invoice Disc. Misc. Charges |
|
| INNOPREPAY |
Integer |
Invoice No. of Prepayments |
|
| NOSHIPLINE |
Integer |
No. Lines Qty. Shipped |
|
| NOMISCLINE |
Integer |
No. Misc. Charges Lines |
|
| INVNETNOTX |
BCD*10.3 |
Invoice Total Before Tax |
|
| INVITAXTOT |
BCD*10.3 |
Invoice Incl. Tax Total |
|
| INVITMTOT |
BCD*10.3 |
Invoice Item Total Amount |
|
| INVDISCBAS |
BCD*10.3 |
Invoice Discount Base |
|
| INVDISCPER |
BCD*5.5 |
Invoice Discount Percentage |
|
| INVDISCAMT |
BCD*10.3 |
Invoice Discount Amount |
|
| INVMISC |
BCD*10.3 |
Invoice Total Misc. Charges |
|
| INVSUBTOT |
BCD*10.3 |
Invoice Subtotal Amount |
|
| INVNET |
BCD*10.3 |
Invoice Total With Inv. Disc. |
|
| INVETAXTOT |
BCD*10.3 |
Invoice Excl. Tax Total |
|
| INVNETWTX |
BCD*10.3 |
Invoice Total |
|
| INVAMTDUE |
BCD*10.3 |
Invoice Amount Due |
|
| INHOMECURR |
String*3 |
Invoice Home Currency |
Mask: %-3N |
| INRATETYPE |
String*2 |
Invoice Rate Type |
Mask: %-2N |
| INSOURCURR |
String*3 |
Invoice Source Currency |
Mask: %-3N |
| INRATEDATE |
Date |
Invoice Rate Date |
|
| INRATE |
BCD*8.7 |
Invoice Rate |
|
| INSPREAD |
BCD*8.7 |
Invoice Spread |
|
| INDATEMTCH |
Integer |
Invoice Rate Date Matching |
|
| INRATEREP |
Integer |
Invoice Rate Representation |
|
| INRATEOVER |
Boolean |
Invoice Rate Override Flag |
|
| ORDERSOURC |
Integer |
Order Source |
List: 3 entries
| 0 | = | Entered | | 1 | = | Internet | | 2 | = | Electronic Commerce |
|
|