View: Shipments

RotoID: OE0692
Table: OESHIH
Protocol: Header, Key auto generate
DLL:OESHIH

Compositions: 6

RotoID Tables Title DLL
OE0691 OESHID Shipment Details OESHID
OE0999 GENSTUB
OE0190 OECOINS Shipment Comments/Instructions OECOINS
OE0745 OETERMS Shipment Payment Schedules OETERMS
OE0694 OESHIR Multiple Orders to Shipment OESHIR
OE0704 OESHIHO Shipment Optional Fields OESHIHO

Keys: 8

Title Fields
Shipment Uniquifier Key SHIUNIQ
Shipment Number Key SHINUMBER
Order/Shipment ORDNUMBER, SHINUMBER
Customer/Shipment CUSTOMER, SHINUMBER
Reference/Shipment REFERENCE, SHINUMBER
Shipment Completed COMPLETE, SHIUNIQ
Customer/PO No./Order No. CUSTOMER, PONUMBER, ORDNUMBER
Order No./Shipment Completed ORDUNIQ, COMPLETE

Fields: 375

Field Index Type Title Attributes Presentation
SHIUNIQ 1 BCD*10.0 Shipment Uniquifier E A K R 
SHINUMBER 2 String*22 Shipment Number E A  Mask: %-22C
ORDNUMBER 3 String*22 Order Number E A X  Mask: %-22C
DAYENDNUM 4 BCD*10.0 I/C Day End Trans. Number E A C 
CUSTOMER 5 String*12 Customer Number E A  Mask: %-12C
CUSTGROUP 6 String*6 Customer Group Code E A  Mask: %-6C
BILNAME 7 String*60 Bill-To Name E A 
BILADDR1 8 String*60 Bill-To Address Line 1 E A 
BILADDR2 9 String*60 Bill-To Address Line 2 E A 
BILADDR3 10 String*60 Bill-To Address Line 3 E A 
BILADDR4 11 String*60 Bill-To Address Line 4 E A 
BILCITY 12 String*30 Bill-To City E A 
BILSTATE 13 String*30 Bill-To State/Province E A 
BILZIP 14 String*20 Bill-To Zip/Postal Code E A 
BILCOUNTRY 15 String*30 Bill-To Country E A 
BILPHONE 16 String*30 Bill-To Phone Number E A  Mask: (%-3C) %-3C-%-24C
BILFAX 17 String*30 Bill-To Fax Number E A  Mask: (%-3C) %-3C-%-24C
BILCONTACT 18 String*60 Bill-To Contact E A 
BILEMAIL 19 String*50 Bill-To E-mail E A 
BILPHONEC 20 String*30 Bill-To Contact Phone E A  Mask: (%-3C) %-3C-%-24C
BILFAXC 21 String*30 Bill-To Contact Fax E A  Mask: (%-3C) %-3C-%-24C
BILEMAILC 22 String*50 Bill-To Contact E-mail E A 
SHIPTO 23 String*6 Ship-To Location Code E A  Mask: %-6C
SHPNAME 24 String*60 Ship-To Name E A 
SHPADDR1 25 String*60 Ship-To Address Line 1 E A 
SHPADDR2 26 String*60 Ship-To Address Line 2 E A 
SHPADDR3 27 String*60 Ship-To Address Line 3 E A 
SHPADDR4 28 String*60 Ship-To Address Line 4 E A 
SHPCITY 29 String*30 Ship-To City E A 
SHPSTATE 30 String*30 Ship-To State/Province E A 
SHPZIP 31 String*20 Ship-To Zip/Postal Code E A 
SHPCOUNTRY 32 String*30 Ship-To Country E A 
SHPPHONE 33 String*30 Ship-To Phone Number E A  Mask: (%-3C) %-3C-%-24C
SHPFAX 34 String*30 Ship-To Fax Number E A  Mask: (%-3C) %-3C-%-24C
SHPCONTACT 35 String*60 Ship-To Contact E A 
SHPEMAIL 36 String*50 Ship-To E-mail E A 
SHPPHONEC 37 String*30 Ship-To Contact Phone E A  Mask: (%-3C) %-3C-%-24C
SHPFAXC 38 String*30 Ship-To Contact Fax E A  Mask: (%-3C) %-3C-%-24C
SHPEMAILC 39 String*50 Ship-To Contact E-mail E A 
CUSTDISC 40 Integer Customer Discount Level E A  List:6 entries
0 = Base
1 = A
2 = B
3 = C
4 = D
5 = E
PRICELIST 41 String*6 Default Price List Code E A  Mask: %-6N
PONUMBER 42 String*22 Purchase Order Number E A X  Mask: %-22C
TERRITORY 43 String*6 Territory E A  Mask: %-6N
TERMS 44 String*6 Terms Code E A  Mask: %-6N
REFERENCE 45 String*60 Shipment Reference E A 
SHIDATE 46 Date Shipment Date E A 
EXPDATE 47 Date Expected Ship Date E A 
SHIPVIA 48 String*6 Ship-Via Code E A  Mask: %-6N
VIADESC 49 String*60 Ship-Via Code Description E A 
SHIFISCYR 50 String*4 Shipment Fiscal Year E A  Mask: %-4d
SHIFISCPER 51 Integer Shipment 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
LASTINVNUM 52 String*22 Last Invoice Number E A C  Mask: %-22C
NUMINVOICE 53 Integer Number of Invoices E A 
FOB 54 String*60 Free On Board Point E A 
TEMPLATE 55 String*6 Template Code E A  Mask: %-6N
LOCATION 56 String*6 Default Location Code E A  Mask: %-6N
DESC 57 String*60 Shipment Description E A 
COMMENT 58 String*250 Shipment Comment E A 
OVERCREDIT 59 Boolean Over Credit Limit E A C 
APPROVELMT 60 BCD*10.3 Approved Limit A C X 
APPROVEBY 61 String*8 Authorizing User ID E A C  Mask: %-8N
PRINTSTAT 62 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 63 Date Last Posting Date E A C 
SHIPLABEL 64 Boolean Requires Shipping Labels E A C 
LBLPRINTED 65 Boolean Shipping Labels Printed E A C 
SHHOMECURR 66 String*3 Shipment Home Currency E A C  Mask: %-3N
SHRATETYPE 67 String*2 Shipment Rate Type E A X  Mask: %-2N
SHSOURCURR 68 String*3 Shipment Source Currency E A  Mask: %-3N
SHRATEDATE 69 Date Shipment Rate Date E A X 
SHRATE 70 BCD*8.7 Shipment Rate E A X 
SHSPREAD 71 BCD*8.7 Shipment Spread E A C 
SHDATEMTCH 72 Integer Shipment Rate Date Matching E A C 
SHRATEREP 73 Integer Shipment Rate Operator E A C 
SHRATEOVER 74 Boolean Shipment Rate Override Flag E A C 
SHITOTAL 75 BCD*10.3 Total Amt. Items E A C 
SHIMTOTAL 76 BCD*10.3 Total Amt. Misc. Charges E A C 
SHILINES 77 Integer Number of Lines on Shipment E A C 
NUMLABELS 78 Integer Number of Labels E A 
SHIPAYTOT 79 BCD*10.3 Prev. Payments Total E A C 
SHIPYDSTOT 80 BCD*10.3 Prev. Payment Disc. Total E A C 
SALESPER1 81 String*8 Salesperson 1 E A  Mask: %-8N
SALESPER2 82 String*8 Salesperson 2 E A  Mask: %-8N
SALESPER3 83 String*8 Salesperson 3 E A  Mask: %-8N
SALESPER4 84 String*8 Salesperson 4 E A  Mask: %-8N
SALESPER5 85 String*8 Salesperson 5 E A  Mask: %-8N
SALESPLT1 86 BCD*5.5 Sales Percentage 1 E A 
SALESPLT2 87 BCD*5.5 Sales Percentage 2 E A 
SALESPLT3 88 BCD*5.5 Sales Percentage 3 E A 
SALESPLT4 89 BCD*5.5 Sales Percentage 4 E A 
SALESPLT5 90 BCD*5.5 Sales Percentage 5 E A 
RECALCTAX 91 Boolean Recalculate Tax E A C 
TAXOVERRD 92 Boolean Tax Overridden E A C 
TAXGROUP 93 String*12 Tax Group E A X  Mask: %-12N
TAUTH1 94 String*12 Tax Authority 1 E A  Mask: %-12N
TAUTH2 95 String*12 Tax Authority 2 E A  Mask: %-12N
TAUTH3 96 String*12 Tax Authority 3 E A  Mask: %-12N
TAUTH4 97 String*12 Tax Authority 4 E A  Mask: %-12N
TAUTH5 98 String*12 Tax Authority 5 E A  Mask: %-12N
TCLASS1 99 Integer Tax Class 1 E A X 
TCLASS2 100 Integer Tax Class 2 E A X 
TCLASS3 101 Integer Tax Class 3 E A X 
TCLASS4 102 Integer Tax Class 4 E A X 
TCLASS5 103 Integer Tax Class 5 E A X 
TBASE1 104 BCD*10.3 Tax Base 1 A C X 
TBASE2 105 BCD*10.3 Tax Base 2 A C X 
TBASE3 106 BCD*10.3 Tax Base 3 A C X 
TBASE4 107 BCD*10.3 Tax Base 4 A C X 
TBASE5 108 BCD*10.3 Tax Base 5 A C X 
TEAMOUNT1 109 BCD*10.3 Excluded Tax Amount 1 E A C 
TEAMOUNT2 110 BCD*10.3 Excluded Tax Amount 2 E A C 
TEAMOUNT3 111 BCD*10.3 Excluded Tax Amount 3 E A C 
TEAMOUNT4 112 BCD*10.3 Excluded Tax Amount 4 E A C 
TEAMOUNT5 113 BCD*10.3 Excluded Tax Amount 5 E A C 
TIAMOUNT1 114 BCD*10.3 Included Tax Amount 1 E A C 
TIAMOUNT2 115 BCD*10.3 Included Tax Amount 2 E A C 
TIAMOUNT3 116 BCD*10.3 Included Tax Amount 3 E A C 
TIAMOUNT4 117 BCD*10.3 Included Tax Amount 4 E A C 
TIAMOUNT5 118 BCD*10.3 Included Tax Amount 5 E A C 
TEXEMPT1 119 String*20 Registration 1 E A X 
TEXEMPT2 120 String*20 Registration 2 E A X 
TEXEMPT3 121 String*20 Registration 3 E A X 
TEXEMPT4 122 String*20 Registration 4 E A X 
TEXEMPT5 123 String*20 Registration 5 E A X 
COMPLETE 132 Integer Shipment 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 133 Date Shipment Completion Date E A C 
SHIWEIGHT 134 BCD*10.4 Shipment Total Est. Weight E A C 
NEXTDTLNUM 135 Integer Next Detail Number E A C 
SDISONMISC 136 Boolean Shipment Disc. Misc. Charges E A 
NOSHIPLINE 137 Integer No. Lines Qty. Shipped E A C 
NOMISCLINE 138 Integer No. Misc. Charges Lines E A C 
SHINETNOTX 139 BCD*10.3 Shipment Total Before Tax E A C 
SHIITAXTOT 140 BCD*10.3 Shipment Incl. Tax Total E A C 
SHIITMTOT 141 BCD*10.3 Shipment Item Total Amount E A C 
SHIDISCBAS 142 BCD*10.3 Shipment Discount Base E A C 
SHIDISCPER 143 BCD*5.5 Shipment Discount Percentage E A 
SHIDISCAMT 144 BCD*10.3 Shipment Discount Amount E A 
SHIMISC 145 BCD*10.3 Shipment Total Misc. Charges E A C 
SHISUBTOT 146 BCD*10.3 Shipment Subtotal Amount E A C 
SHINET 147 BCD*10.3 Shipment Total With Inv. Disc. E A C 
SHIETAXTOT 148 BCD*10.3 Shipment Excl. Tax Total E A C 
SHINETWTX 149 BCD*10.3 Shipment Total E A C 
ORDDATE 150 Date Order Date E A C 
ORHOMECURR 151 String*3 Order Home Currency E A C  Mask: %-3N
ORRATETYPE 152 String*2 Order Rate Type E A C  Mask: %-2N
ORSOURCURR 153 String*3 Order Source Currency E A C  Mask: %-3N
ORRATEDATE 154 Date Order Rate Date E A C 
ORRATE 155 BCD*8.7 Order Rate E A C 
ORSPREAD 156 BCD*8.7 Order Spread E A C 
ORDATEMTCH 157 Integer Order Rate Date Matching E A C 
ORRATEREP 158 Integer Order Rate Operator E A C 
ORRATEOVER 159 Boolean Order Rate Override Flag E A C 
AUTOTAXCAL 160 Boolean Auto-Tax Calculation Status E A X 
MULTIORD 161 Boolean Generate From Multiple Orders E A X  List:2 entries
0 = No
1 = Yes
ORDS 162 Integer From How Many Orders E A C 
SHIPTRACK 163 String*36 Shipment Tracking Number E A 
NUMSHPMENT 164 Integer Number of Shipments E A 
VALUES 165 Long Optional Fields E A C 
ORDUNIQ 166 BCD*10.0 Order Uniquifier E A 
ITEMDISTOT 167 BCD*10.3 Item Detail Discount Total E A 
MISCDISTOT 168 BCD*10.3 Misc. Charge Detail Discount Total E A 
STRMETHOD 169 Integer Auto-Calc. Tax Reporting Amounts E A X 
STRCURRNCY 170 String*3 Tax Reporting (TR) Currency E A C  Mask: %-3N
STRRATTYPE 171 String*2 TR Rate Type E A X  Mask: %-2N
STRRATDATE 172 Date TR Rate Date E A X 
STRRATE 173 BCD*8.7 TR Rate E A X 
STRSPREAD 174 BCD*8.7 TR Spread E A C 
STRDATMTCH 175 Integer TR Rate Date Matching E A C 
STRRATEOP 176 Integer TR Rate Operator E A C 
STRRATOVER 177 Boolean TR Rate Override Flag E A C 
STREAMNT1 178 BCD*10.3 TR Excluded Tax Amount 1 E A C 
STREAMNT2 179 BCD*10.3 TR Excluded Tax Amount 2 E A C 
STREAMNT3 180 BCD*10.3 TR Excluded Tax Amount 3 E A C 
STREAMNT4 181 BCD*10.3 TR Excluded Tax Amount 4 E A C 
STREAMNT5 182 BCD*10.3 TR Excluded Tax Amount 5 E A C 
STRIAMNT1 183 BCD*10.3 TR Included Tax Amount 1 E A C 
STRIAMNT2 184 BCD*10.3 TR Included Tax Amount 2 E A C 
STRIAMNT3 185 BCD*10.3 TR Included Tax Amount 3 E A C 
STRIAMNT4 186 BCD*10.3 TR Included Tax Amount 4 E A C 
STRIAMNT5 187 BCD*10.3 TR Included Tax Amount 5 E A C 
OTRCURRNCY 188 String*3 Tax Reporting (TR) Order Currency E A C  Mask: %-3N
OTRRATTYPE 189 String*2 TR Order Rate Type E A C  Mask: %-2N
OTRRATDATE 190 Date TR Order Rate Date E A C 
OTRRATE 191 BCD*8.7 TR Order Rate E A C 
OTRSPREAD 192 BCD*8.7 TR Order Spread E A C 
OTRDATMTCH 193 Integer TR Order Rate Date Matching E A C 
OTRRATEOP 194 Integer TR Order Rate Operator E A C 
OTRRATOVER 195 Boolean TR Order Rate Override Flag E A C 
DISAMTOVER 196 Boolean Shipment Discount Amount Override E A C 
SHNOPREPAY 197 Integer Shipment No. of Prepayments E A C 
JOBLINES 198 Long Job Related Detail Lines E A C 
LNINVABLE 199 Long Invoiceable Detail Lines E A C 
HASRTG 200 Boolean Has Retainage A X  List:2 entries
0 = No
1 = Yes
RTGTERMS 201 String*6 Retainage Terms A X  Mask: %-6N
RTGAMOUNT 202 BCD*10.3 Retainage Amount E A C 
RTGPERCENT 203 BCD*5.5 Retainage Percent A X 
RTGRATE 204 Integer Retainage Exchange Rate A X  List:2 entries
0 = Use Original Document Exchange Rate
1 = Use Current Exchange Rate
RTGTXBASE1 205 BCD*10.3 Retainage Tax Base 1 E A 
RTGTXBASE2 206 BCD*10.3 Retainage Tax Base 2 E A 
RTGTXBASE3 207 BCD*10.3 Retainage Tax Base 3 E A 
RTGTXBASE4 208 BCD*10.3 Retainage Tax Base 4 E A 
RTGTXBASE5 209 BCD*10.3 Retainage Tax Base 5 E A 
RTGTXAMT1 210 BCD*10.3 Retainage Tax Amount 1 E A 
RTGTXAMT2 211 BCD*10.3 Retainage Tax Amount 2 E A 
RTGTXAMT3 212 BCD*10.3 Retainage Tax Amount 3 E A 
RTGTXAMT4 213 BCD*10.3 Retainage Tax Amount 4 E A 
RTGTXAMT5 214 BCD*10.3 Retainage Tax Amount 5 E A 
CUSACCTSET 215 String*6 Customer Account Set E A  Mask: %-6N
ENTEREDBY 216 String*8 Entered By E A C  Mask: %-8N
DATEBUS 217 Date Posting Date E A 
OPPOLINES 218 Integer Sage CRM Opportunity Lines E A C 
PCODDESC 400 String*60 Price List Code Desc. E A 
TERMDESC 401 String*60 Terms Code Description E A 
TXGRPDESC 402 String*60 Tax Group Code Desc. E A 
LOCDESC 403 String*60 Location Code Desc. E A 
SALES1NAME 404 String*60 Salesperson Name 1 E A C 
SALES2NAME 405 String*60 Salesperson Name 2 E A C 
SALES3NAME 406 String*60 Salesperson Name 3 E A C 
SALES4NAME 407 String*60 Salesperson Name 4 E A C 
SALES5NAME 408 String*60 Salesperson Name 5 E A C 
TAUTH1DESC 409 String*60 Tax Authority 1 Desc. E A C 
TAUTH2DESC 410 String*60 Tax Authority 2 Desc. E A C 
TAUTH3DESC 411 String*60 Tax Authority 3 Desc. E A C 
TAUTH4DESC 412 String*60 Tax Authority 4 Desc. E A C 
TAUTH5DESC 413 String*60 Tax Authority 5 Desc. E A C 
TCLAS1DESC 414 String*60 Tax Class 1 Description E A C 
TCLAS2DESC 415 String*60 Tax Class 2 Description E A C 
TCLAS3DESC 416 String*60 Tax Class 3 Description E A C 
TCLAS4DESC 417 String*60 Tax Class 4 Description E A C 
TCLAS5DESC 418 String*60 Tax Class 5 Description E A C 
SHSRCDESC 419 String*60 Shipment Source Curr. Desc. E A 
SHHOMDESC 420 String*60 Shipment Home Currency Desc. E A 
SHRTTYDESC 421 String*60 Shipment Rate Type Desc. E A 
ORSRCDESC 422 String*60 Shipment Source Currency Desc. E A 
ORHOMDESC 423 String*60 Shipment Home Currency Desc. E A 
ORRTTYDESC 424 String*60 Shipment Rate Type Description E A 
TAMOUNT1 425 BCD*10.3 Total Tax Amount 1 A C X 
TAMOUNT2 426 BCD*10.3 Total Tax Amount 2 A C X 
TAMOUNT3 427 BCD*10.3 Total Tax Amount 3 A C X 
TAMOUNT4 428 BCD*10.3 Total Tax Amount 4 A C X 
TAMOUNT5 429 BCD*10.3 Total Tax Amount 5 A C X 
SHITAXTOT 430 BCD*10.3 Total Tax Amount E A 
RUNNINGTOT 431 BCD*10.3 Shipment Running Total E A 
GOCALCTAX 432 Boolean Perform Tax Calculation E A 
GOSHIPALL 433 Boolean Perform Ship All E A 
DOSCONVERT 434 Boolean DOS Conversion in Progress E A  List:2 entries
0 = No
1 = Yes
GOFCALCTAX 435 Boolean Perform Forced Tax Calculation E A 
GODISTTAX 436 Boolean Perform Manual Tax Distribution E A 
TXCALCINPG 437 Boolean Tax Calculation in Progress E A C 
RTWARNMSG 448 Boolean Display Rate Warning E A 
CUSTEXIST 449 Boolean Customer Exists E A 
SECENABLED 450 Boolean Security Enabled E A 
GOAPPROSEC 451 Boolean User Can Approve Credit Lift E A 
GOCHKCRDT 452 Boolean Perform Credit Limit Check E A 
APPPASSWRD 453 String*64 Authorizing User Password E A X 
SWPARTSHIP 454 Integer Allow partial shipments E A  List:2 entries
0 = No
1 = Yes
SHIP1ORDER 455 Boolean Generate Ship. from Single Order E A 
SHIPORDERS 456 Boolean Generate Ship. from Mult. Orders E A 
CREATEINV 457 Boolean Create Invoice from Shipment E A X 
INVNUMBER 458 String*22 Invoice Number E A  Mask: %-22C
POSTSEQNUM 460 Long Post Sequence Number A C 
INVUNIQ 461 BCD*10.0 Invoice Uniquifier E A 
INVDATE 462 Date Invoice Date E A 
INHOMECURR 463 String*3 Invoice Home Currency E A C  Mask: %-3N
INRATETYPE 464 String*2 Invoice Rate Type E A X  Mask: %-2N
INSOURCURR 465 String*3 Invoice Source Currency E A C  Mask: %-3N
INRATEDATE 466 Date Invoice Rate Date E A X 
INRATE 467 BCD*8.7 Invoice Rate E A X 
INSPREAD 468 BCD*8.7 Invoice Spread E A C 
INDATEMTCH 469 Integer Invoice Rate Date Matching E A C 
INRATEREP 470 Integer Invoice Rate Operator E A C 
INRATEOVER 471 Boolean Invoice Rate Override Flag E A C 
INSRCDESC 472 String*60 Invoice Source Currency Desc. E A 
INHOMDESC 473 String*60 Invoice Home Currency Desc. E A 
INRTTYDESC 474 String*60 Invoice Rate Type Description E A 
FROMORDER 475 Boolean Created from Order E A 
PROCESSCMD 476 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 477 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 478 BCD*10.3 User-Entered Approval Amount E A C 
SWCHKLIMC 479 Boolean Checking Customer Credit Limit E A C 
SWCHKODUEC 480 Boolean Checking Customer Aging Limit E A C 
SWCHKLIMA 481 Boolean Checking Nat. Acct. Credit Limit E A C 
SWCHKODUEA 482 Boolean Checking Nat. Acct. Aging Limit E A C 
SWOVERLIMC 483 Boolean Customer Is Over Credit Limit E A C 
SWOVERDUEC 484 Boolean Customer Is Over Aging Limit E A C 
SWOVERLIMA 485 Boolean Nat. Acct. Is Over Credit Limit E A C 
SWOVERDUEA 486 Boolean Nat. Acct. Is Over Aging Limit E A C 
AMTLIMITC 487 BCD*10.3 Customer Credit Limit E A C 
AMTBALCUST 488 BCD*10.3 Customer Balance (Posted) E A C 
OVDUEDAYSC 489 Integer Customer Days Overdue E A C 
OVDUELMTC 490 BCD*10.3 Customer Overdue Limit E A C 
OVDUEBALC 491 BCD*10.3 Customer Balance Overdue E A C 
AMTLIMITA 492 BCD*10.3 Nat. Acct. Credit Limit E A C 
AMTBALACCT 493 BCD*10.3 Nat. Acct. Balance E A C 
OVDUEDAYSA 494 Integer Nat. Acct. Days Overdue E A C 
OVDUELMTA 495 BCD*10.3 Nat. Acct. Overdue Limit E A C 
OVDUEBALA 496 BCD*10.3 Nat. Acct. Balance Overdue E A C 
SWARPEND 497 Boolean A/R Pending Trans. Included E A C 
SWOEPEND 498 Boolean O/E Pending Trans. Included E A C 
SWXXPEND 499 Boolean Other Pending Trans. Included E A C 
AMTARPEND 500 BCD*10.3 A/R Pending Balance E A C 
AMTOEPEND 501 BCD*10.3 O/E Pending Balance E A C 
AMTXXPEND 502 BCD*10.3 Other Pending Balance E A C 
AMTTOTCUST 503 BCD*10.3 Customer Total Outstanding E A C 
AMTTOTACCT 504 BCD*10.3 Nat. Acct. Total Outstanding E A C 
AMTLEFTC 505 BCD*10.3 Customer Limit Left E A C 
AMTLEFTA 506 BCD*10.3 Nat. Acct. Limit Left E A C 
AMTOVERC 507 BCD*10.3 Customer Limit Exceeded E A C 
AMTOVERA 508 BCD*10.3 Nat. Acct. Limit Exceeded E A C 
AMTLASTIVT 509 BCD*10.3 Last Invoice Amount E A C 
DATELASTIV 510 Date Last Invoice Date E A C 
AMTLASTPYT 511 BCD*10.3 Last Payment Amount E A C 
DATELASTPA 512 Date Last Payment Date E A C 
DRIVENBYUI 513 Boolean Driven by UI E A 
DTLDISCTOT 514 BCD*10.3 Detail Discount Total E A C 
DTLDISCPER 515 BCD*5.5 Detail Discount Percentage E A C 
SHINTDTDIS 516 BCD*10.3 Document Net of Detail Disc. E A C 
STRAMOUNT1 517 BCD*10.3 TR Tax Amount 1 A C X 
STRAMOUNT2 518 BCD*10.3 TR Tax Amount 2 A C X 
STRAMOUNT3 519 BCD*10.3 TR Tax Amount 3 A C X 
STRAMOUNT4 520 BCD*10.3 TR Tax Amount 4 A C X 
STRAMOUNT5 521 BCD*10.3 TR Tax Amount 5 A C X 
STRETOTAL 522 BCD*10.3 TR Excluded Tax Total E A C 
STRITOTAL 523 BCD*10.3 TR Included Tax Total E A C 
STRTOTAL 524 BCD*10.3 TR Tax Total E A C 
ITRCURRNCY 525 String*3 Tax Reporting Invoice (TR) Currency E A C  Mask: %-3N
ITRRATTYPE 526 String*2 TR Invoice Rate Type E A X  Mask: %-2N
ITRRATDATE 527 Date TR Invoice Rate Date E A X 
ITRRATE 528 BCD*8.7 TR Invoice Rate E A X 
ITRSPREAD 529 BCD*8.7 TR Invoice Spread E A C 
ITRDATMTCH 530 Integer TR Invoice Rate Date Matching E A C 
ITRRATEOP 531 Integer TR Invoice Rate Operator E A C 
ITRRATOVER 532 Boolean TR Invoice Rate Override Flag E A C 
OTRCURDESC 533 String*60 TR Currency Description E A 
STRCURDESC 534 String*60 TR Shipment Currency Description E A 
ITRCURDESC 535 String*60 TR Invoice Currency Description E A 
OTRRTYDESC 536 String*60 TR Rate Type Description E A 
STRRTYDESC 537 String*60 TR Shipment Rate Type Description E A 
ITRRTYDESC 538 String*60 TR Invoice Rate Type Description E A 
REBATCHNUM 539 BCD*5.0 Receipt Batch Number E A 
BANKCODE 540 String*8 Bank Code E A  Mask: %-8N
BANKRECTYP 541 String*12 Receipt Type E A  Mask: %-12C
CHECKDATE 542 Date Check Date E A 
CHKFISCYR 543 String*4 Check Fiscal Year E A  Mask: %-4d
CHKFISCPER 544 Integer Check Fiscal Period E A P 
CHECKNUM 545 String*24 Check Number E A 
APPLYTO 546 Integer Payment Applied To E A  List:3 entries
2 = Invoice No.
4 = Order No.
9 = Shipment No.
PAYMENT 547 BCD*10.3 Payment In Cust. Currency E A 
PAYDISC 548 BCD*10.3 Payment Disc. E A 
BANKPAYMNT 549 BCD*10.3 Payment In Bank Currency E A 
PENDPREPAY 550 BCD*10.3 Pending Prepayment Amount E A 
PAHOMECURR 551 String*3 Payment Home Currency E A  Mask: %-3N
PARATETYPE 552 String*2 Payment Rate Type E A  Mask: %-2N
PASOURCURR 553 String*3 Payment Source Currency E A  Mask: %-3N
PARATEDATE 554 Date Payment Rate Date E A 
PARATE 555 BCD*8.7 Payment Rate E A 
PASPREAD 556 BCD*8.7 Payment Spread E A 
PADATEMTCH 557 Integer Payment Rate Date Matching E A 
PARATEREP 558 Integer Payment Rate Operator E A 
PAYMTYPE 559 Integer Payment Type E A  List:6 entries
0 = (None)
1 = Cash
2 = Check
3 = Credit Card
4 = Other
5 = SPS Credit Card
SHIPAYMENT 564 BCD*10.3 Shipment Total Payment E A 
SHIAMTDUE 565 BCD*10.3 Shipment Amount Due E A 
AMTDUENODS 566 BCD*10.3 Amount Due Less Curr. Prepayment E A 
HASJOB 567 Boolean Job Related A X  List:2 entries
0 = No
1 = Yes
NONINVABLE 568 Boolean Project Invoicing A X  List:2 entries
0 = No
1 = Yes
RTGTERMDSC 569 String*60 Retainage Terms Description A 
CUSACTDESC 570 String*60 Customer Account Set Description E A C 
INVDATEBUS 571 Date Invoice Posting Date E A 
ORDPAYTOT 572 BCD*10.3 Order Payments Total E A 
PAYDISTTOT 573 BCD*10.3 Prepayment Distributed Amount E A C 
UNAPPLDPAY 574 BCD*10.3 Prepayment Unapplied Amount E A C 
RTXAMTTOT 575 BCD*10.3 Total Retainage Tax Amount E A C 
PAUTHEXIST 576 Boolean Pre-Auth Exists for the Shipment E A C  List:2 entries
0 = No
1 = Yes
PAYMONORD 577 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 578 String*12 Payment Code On Order E A 
IDCARD 579 String*12 Payment Card ID E A 

This page was generated on 2023-Aug-31

© 2023 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).