| SHIUNIQ |
BCD*10.0 |
Shipment Uniquifier |
|
| AUDTDATE |
Date |
|
|
| AUDTTIME |
Time |
|
|
| AUDTUSER |
String*8 |
|
|
| AUDTORG |
String*6 |
|
|
| SHINUMBER |
String*22 |
Shipment Number |
Mask: %-22C |
| ORDNUMBER |
String*22 |
Order Number |
Mask: %-22C |
| DAYENDNUM |
BCD*10.0 |
I/C Day End Trans. Number |
|
| CUSTOMER |
String*12 |
Customer Number |
Mask: %-12C |
| CUSTGROUP |
String*6 |
Customer Group Code |
Mask: %-6C |
| BILNAME |
String*60 |
Bill-To Name |
|
| BILADDR1 |
String*60 |
Bill-To Address Line 1 |
|
| BILADDR2 |
String*60 |
Bill-To Address Line 2 |
|
| BILADDR3 |
String*60 |
Bill-To Address Line 3 |
|
| BILADDR4 |
String*60 |
Bill-To Address Line 4 |
|
| BILCITY |
String*30 |
Bill-To City |
|
| BILSTATE |
String*30 |
Bill-To State/Province |
|
| BILZIP |
String*20 |
Bill-To Zip/Postal Code |
|
| BILCOUNTRY |
String*30 |
Bill-To Country |
|
| BILPHONE |
String*30 |
Bill-To Phone Number |
Mask: (%-3C) %-3C-%-24C |
| BILFAX |
String*30 |
Bill-To Fax Number |
Mask: (%-3C) %-3C-%-24C |
| BILCONTACT |
String*60 |
Bill-To Contact |
|
| BILEMAIL |
String*50 |
Bill-To E-mail |
|
| BILPHONEC |
String*30 |
Bill-To Contact Phone |
Mask: (%-3C) %-3C-%-24C |
| BILFAXC |
String*30 |
Bill-To Contact Fax |
Mask: (%-3C) %-3C-%-24C |
| BILEMAILC |
String*50 |
Bill-To Contact E-mail |
|
| SHIPTO |
String*6 |
Ship-To Location Code |
Mask: %-6C |
| SHPNAME |
String*60 |
Ship-To Name |
|
| SHPADDR1 |
String*60 |
Ship-To Address Line 1 |
|
| SHPADDR2 |
String*60 |
Ship-To Address Line 2 |
|
| SHPADDR3 |
String*60 |
Ship-To Address Line 3 |
|
| SHPADDR4 |
String*60 |
Ship-To Address Line 4 |
|
| SHPCITY |
String*30 |
Ship-To City |
|
| SHPSTATE |
String*30 |
Ship-To State/Province |
|
| SHPZIP |
String*20 |
Ship-To Zip/Postal Code |
|
| SHPCOUNTRY |
String*30 |
Ship-To Country |
|
| SHPPHONE |
String*30 |
Ship-To Phone Number |
Mask: (%-3C) %-3C-%-24C |
| SHPFAX |
String*30 |
Ship-To Fax Number |
Mask: (%-3C) %-3C-%-24C |
| SHPCONTACT |
String*60 |
Ship-To Contact |
|
| SHPEMAIL |
String*50 |
Ship-To E-mail |
|
| SHPPHONEC |
String*30 |
Ship-To Contact Phone |
Mask: (%-3C) %-3C-%-24C |
| SHPFAXC |
String*30 |
Ship-To Contact Fax |
Mask: (%-3C) %-3C-%-24C |
| SHPEMAILC |
String*50 |
Ship-To Contact E-mail |
|
| CUSTDISC |
Integer |
Customer Discount Level |
List:6 entries
| 0 |
= |
Base |
| 1 |
= |
A |
| 2 |
= |
B |
| 3 |
= |
C |
| 4 |
= |
D |
| 5 |
= |
E |
|
| PRICELIST |
String*6 |
Default Price List Code |
Mask: %-6N |
| PONUMBER |
String*22 |
Purchase Order Number |
Mask: %-22C |
| TERRITORY |
String*6 |
Territory |
Mask: %-6N |
| TERMS |
String*6 |
Terms Code |
Mask: %-6N |
| REFERENCE |
String*60 |
Shipment Reference |
|
| SHIDATE |
Date |
Shipment Date |
|
| EXPDATE |
Date |
Expected Ship Date |
|
| SHIPVIA |
String*6 |
Ship-Via Code |
Mask: %-6N |
| VIADESC |
String*60 |
Ship-Via Code Description |
|
| SHIFISCYR |
String*4 |
Shipment Fiscal Year |
Mask: %-4d |
| SHIFISCPER |
Integer |
Shipment 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 |
|
| LASTINVNUM |
String*22 |
Last Invoice Number |
Mask: %-22C |
| NUMINVOICE |
Integer |
Number of Invoices |
|
| FOB |
String*60 |
Free On Board Point |
|
| TEMPLATE |
String*6 |
Template Code |
Mask: %-6N |
| LOCATION |
String*6 |
Default Location Code |
Mask: %-6N |
| DESC |
String*60 |
Shipment Description |
|
| COMMENT |
String*250 |
Shipment Comment |
|
| OVERCREDIT |
Boolean |
Over Credit Limit |
|
| APPROVELMT |
BCD*10.3 |
Approved Limit |
|
| APPROVEBY |
String*8 |
Authorizing User ID |
Mask: %-8N |
| 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 |
|
| SHIPLABEL |
Boolean |
Requires Shipping Labels |
|
| LBLPRINTED |
Boolean |
Shipping Labels Printed |
|
| SHHOMECURR |
String*3 |
Shipment Home Currency |
Mask: %-3N |
| SHRATETYPE |
String*2 |
Shipment Rate Type |
Mask: %-2N |
| SHSOURCURR |
String*3 |
Shipment Source Currency |
Mask: %-3N |
| SHRATEDATE |
Date |
Shipment Rate Date |
|
| SHRATE |
BCD*8.7 |
Shipment Rate |
|
| SHSPREAD |
BCD*8.7 |
Shipment Spread |
|
| SHDATEMTCH |
Integer |
Shipment Rate Date Matching |
|
| SHRATEREP |
Integer |
Shipment Rate Operator |
|
| SHRATEOVER |
Boolean |
Shipment Rate Override Flag |
|
| SHITOTAL |
BCD*10.3 |
Total Amt. Items |
|
| SHIMTOTAL |
BCD*10.3 |
Total Amt. Misc. Charges |
|
| SHILINES |
Integer |
Number of Lines on Shipment |
|
| NUMLABELS |
Integer |
Number of Labels |
|
| SHIPAYTOT |
BCD*10.3 |
Prev. Payments Total |
|
| SHIPYDSTOT |
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*12 |
Tax Group |
Mask: %-12N |
| TAUTH1 |
String*12 |
Tax Authority 1 |
Mask: %-12N |
| TAUTH2 |
String*12 |
Tax Authority 2 |
Mask: %-12N |
| TAUTH3 |
String*12 |
Tax Authority 3 |
Mask: %-12N |
| TAUTH4 |
String*12 |
Tax Authority 4 |
Mask: %-12N |
| TAUTH5 |
String*12 |
Tax Authority 5 |
Mask: %-12N |
| 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 |
|
| COMPLETE |
Integer |
Shipment Completed |
List:5 entries
| 1 |
= |
Incomplete/Not Included |
| 2 |
= |
Incomplete/Included |
| 3 |
= |
Complete/Not Included |
| 4 |
= |
Complete/Included |
| 5 |
= |
Complete/Day End |
|
| COMPDATE |
Date |
Shipment Completion Date |
|
| SHIWEIGHT |
BCD*10.4 |
Shipment Total Est. Weight |
|
| NEXTDTLNUM |
Integer |
Next Detail Number |
|
| SDISONMISC |
Boolean |
Shipment Disc. Misc. Charges |
|
| NOSHIPLINE |
Integer |
No. Lines Qty. Shipped |
|
| NOMISCLINE |
Integer |
No. Misc. Charges Lines |
|
| SHINETNOTX |
BCD*10.3 |
Shipment Total Before Tax |
|
| SHIITAXTOT |
BCD*10.3 |
Shipment Incl. Tax Total |
|
| SHIITMTOT |
BCD*10.3 |
Shipment Item Total Amount |
|
| SHIDISCBAS |
BCD*10.3 |
Shipment Discount Base |
|
| SHIDISCPER |
BCD*5.5 |
Shipment Discount Percentage |
|
| SHIDISCAMT |
BCD*10.3 |
Shipment Discount Amount |
|
| SHIMISC |
BCD*10.3 |
Shipment Total Misc. Charges |
|
| SHISUBTOT |
BCD*10.3 |
Shipment Subtotal Amount |
|
| SHINET |
BCD*10.3 |
Shipment Total With Inv. Disc. |
|
| SHIETAXTOT |
BCD*10.3 |
Shipment Excl. Tax Total |
|
| SHINETWTX |
BCD*10.3 |
Shipment Total |
|
| ORDDATE |
Date |
Order Date |
|
| 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 Operator |
|
| ORRATEOVER |
Boolean |
Order Rate Override Flag |
|
| AUTOTAXCAL |
Boolean |
Auto-Tax Calculation Status |
|
| MULTIORD |
Boolean |
Generate From Multiple Orders |
List:2 entries
|
| ORDS |
Integer |
From How Many Orders |
|
| SHIPTRACK |
String*36 |
Shipment Tracking Number |
|
| NUMSHPMENT |
Integer |
Number of Shipments |
|
| VALUES |
Long |
Optional Fields |
|
| ORDUNIQ |
BCD*10.0 |
Order Uniquifier |
|
| ITEMDISTOT |
BCD*10.3 |
Item Detail Discount Total |
|
| MISCDISTOT |
BCD*10.3 |
Misc. Charge Detail Discount Total |
|
| STRMETHOD |
Integer |
Auto-Calc. Tax Reporting Amounts |
|
| STRCURRNCY |
String*3 |
Tax Reporting (TR) Currency |
Mask: %-3N |
| STRRATTYPE |
String*2 |
TR Rate Type |
Mask: %-2N |
| STRRATDATE |
Date |
TR Rate Date |
|
| STRRATE |
BCD*8.7 |
TR Rate |
|
| STRSPREAD |
BCD*8.7 |
TR Spread |
|
| STRDATMTCH |
Integer |
TR Rate Date Matching |
|
| STRRATEOP |
Integer |
TR Rate Operator |
|
| STRRATOVER |
Boolean |
TR Rate Override Flag |
|
| STREAMNT1 |
BCD*10.3 |
TR Excluded Tax Amount 1 |
|
| STREAMNT2 |
BCD*10.3 |
TR Excluded Tax Amount 2 |
|
| STREAMNT3 |
BCD*10.3 |
TR Excluded Tax Amount 3 |
|
| STREAMNT4 |
BCD*10.3 |
TR Excluded Tax Amount 4 |
|
| STREAMNT5 |
BCD*10.3 |
TR Excluded Tax Amount 5 |
|
| STRIAMNT1 |
BCD*10.3 |
TR Included Tax Amount 1 |
|
| STRIAMNT2 |
BCD*10.3 |
TR Included Tax Amount 2 |
|
| STRIAMNT3 |
BCD*10.3 |
TR Included Tax Amount 3 |
|
| STRIAMNT4 |
BCD*10.3 |
TR Included Tax Amount 4 |
|
| STRIAMNT5 |
BCD*10.3 |
TR Included Tax Amount 5 |
|
| OTRCURRNCY |
String*3 |
Tax Reporting (TR) Order Currency |
Mask: %-3N |
| OTRRATTYPE |
String*2 |
TR Order Rate Type |
Mask: %-2N |
| OTRRATDATE |
Date |
TR Order Rate Date |
|
| OTRRATE |
BCD*8.7 |
TR Order Rate |
|
| OTRSPREAD |
BCD*8.7 |
TR Order Spread |
|
| OTRDATMTCH |
Integer |
TR Order Rate Date Matching |
|
| OTRRATEOP |
Integer |
TR Order Rate Operator |
|
| OTRRATOVER |
Boolean |
TR Order Rate Override Flag |
|
| DISAMTOVER |
Boolean |
Shipment Discount Amount Override |
|
| SHNOPREPAY |
Integer |
Shipment No. of Prepayments |
|
| JOBLINES |
Long |
Job Related Detail Lines |
|
| LNINVABLE |
Long |
Invoiceable Detail Lines |
|
| HASRTG |
Boolean |
Has Retainage |
List:2 entries
|
| RTGTERMS |
String*6 |
Retainage Terms |
Mask: %-6N |
| RTGAMOUNT |
BCD*10.3 |
Retainage Amount |
|
| RTGPERCENT |
BCD*5.5 |
Retainage Percent |
|
| RTGRATE |
Integer |
Retainage Exchange Rate |
List:2 entries
| 0 |
= |
Use Original Document Exchange Rate |
| 1 |
= |
Use Current Exchange Rate |
|
| RTGTXBASE1 |
BCD*10.3 |
Retainage Tax Base 1 |
|
| RTGTXBASE2 |
BCD*10.3 |
Retainage Tax Base 2 |
|
| RTGTXBASE3 |
BCD*10.3 |
Retainage Tax Base 3 |
|
| RTGTXBASE4 |
BCD*10.3 |
Retainage Tax Base 4 |
|
| RTGTXBASE5 |
BCD*10.3 |
Retainage Tax Base 5 |
|
| RTGTXAMT1 |
BCD*10.3 |
Retainage Tax Amount 1 |
|
| RTGTXAMT2 |
BCD*10.3 |
Retainage Tax Amount 2 |
|
| RTGTXAMT3 |
BCD*10.3 |
Retainage Tax Amount 3 |
|
| RTGTXAMT4 |
BCD*10.3 |
Retainage Tax Amount 4 |
|
| RTGTXAMT5 |
BCD*10.3 |
Retainage Tax Amount 5 |
|
| CUSACCTSET |
String*6 |
Customer Account Set |
Mask: %-6N |
| ENTEREDBY |
String*8 |
Entered By |
Mask: %-8N |
| DATEBUS |
Date |
Posting Date |
|
| OPPOLINES |
Integer |
Sage CRM Opportunity Lines |
|
|