SO_InvoiceHeader SO Invoice Header Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: SO_Invoice_bus,RA_GenerateTransactions_upd,BC_CommonImport
SQL Def: N SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_InvoiceHeader.M4T"
KPRIMARY: InvoiceNo
KBATCH: BatchNo+InvoiceNo
KCUSTOMER: ARDivisionNo+CustomerNo+InvoiceNo
KCOMPANYID: CRMCompanyID+InvoiceNo
KPERSONID: CRMPersonID+InvoiceNo
Fld Column Name M/L TUR Description/Notes Class
1 InvoiceNo . . . . . . . . . . 7 SYY Invoice Number. . . . . . . . .INVOICE
FmtType:MASTERNUM Next:Invoic
eNo$ Notes: {SO5$(1,7)}
2 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE
DepVal:REQUIRED Notes:
{SO5$(8,6)}
3 InvoiceType . . . . . . . . . 2 SYN Invoice Type. . . . . . . . . .
Valid:CM,DM,IN,AD,FC,CA,XD
Notes: CM=Credit Memo,
DM=Debit Memo, IN=Invoice,
AD=Adjustment., FC=Finance
Charge, CA=Cash, XD=Deleted
{SO5$(14,1)}
4 SalesOrderNo. . . . . . . . . 7 SYN Sales Order Number. . . . . . .SALESORDERNO
FmtType:CHARNUM Notes:
{SO5$(15,7)}
5 OrderType . . . . . . . . . . 1 SYN Order Type. . . . . . . . . . .
DfltVal:1 Valid:B,S,1 Notes:
B=Backorder, S=Standard,
1=Step {SO5$(428,1)}
6 OrderStatus . . . . . . . . . 1 SYN Order Status. . . . . . . . . .
Valid:N,O,C,H Notes: N=New,
O=Open, C=Closed, H=Hold
{SO5$(279,1)}
7 OrderDate . . . . . . . . . . 8 SNN Order Date. . . . . . . . . . .DATE
Notes: {SO5$(430,6)}
8 ARDivisionNo. . . . . . . . . 2 SNY AR Division Number. . . . . . .ARDIVISION
Mask:00 FmtType:ZEROFILL
Notes: {SO5$(22,2)}
9 CustomerNo. . . . . . . . . . 20 SYY Customer Number . . . . . . . .CUSTOMERNO
FmtType:MASTERNUMC Notes:
{SO5$(24,7)}
10 BillToName. . . . . . . . . . 30 SNN Bill-To Name. . . . . . . . . .NAME
ValGroup:CustomerRequired
Notes: {SO5$(31,30)}
11 BillToAddress1. . . . . . . . 30 SNN Bill-To Address 1 . . . . . . .ADDRESSLINE
ValGroup:CustomerRequired
Notes: {SO5$(61,30)}
12 BillToAddress2. . . . . . . . 30 SNN Bill-To Address 2 . . . . . . .ADDRESSLINE
ValGroup:CustomerRequired
Notes: {SO5$(91,30)}
13 BillToAddress3. . . . . . . . 30 SNN Bill-To Address 3 . . . . . . .ADDRESSLINE
ValGroup:CustomerRequired
Notes: {SO5$(558,30)}
14 BillToCity. . . . . . . . . . 20 SNN Bill-To City. . . . . . . . . .CITY
ValGroup:CustomerRequired
Notes: {SO5$(121,20)}
15 BillToState . . . . . . . . . 2 SYN Bill To State . . . . . . . . .STATE
ValGroup:CustomerRequired
Notes: {SO5$(141,2)}
16 BillToZipCode . . . . . . . . 10 SYN Bill-To Zip Code. . . . . . . .ZIPCODE
ValGroup:CustomerRequired
Notes: {SO5$(143,10)}
17 BillToCountryCode . . . . . . 3 SYN Bill-To Country Code. . . . . .COUNTRY
ValGroup:CustomerRequired
Notes: {SO5$(588,3)}
18 ShipToCode. . . . . . . . . . 4 SYN Ship-To Code. . . . . . . . . .SHIPTO
ValGroup:CustomerRequired
Notes: {SO5$(153,4)}
19 ShipToName. . . . . . . . . . 30 SNN Ship-To Name. . . . . . . . . .NAME
ValGroup:CustomerRequired
Notes: {SO5$(157,30)}
20 ShipToAddress1. . . . . . . . 30 SNN Ship-To Address 1 . . . . . . .ADDRESSLINE
ValGroup:CustomerRequired
Notes: {SO5$(187,30)}
21 ShipToAddress2. . . . . . . . 30 SNN Ship-To Address 2 . . . . . . .ADDRESSLINE
ValGroup:CustomerRequired
Notes: {SO5$(217,30)}
22 ShipToAddress3. . . . . . . . 30 SNN Ship-To Address 3 . . . . . . .ADDRESSLINE
ValGroup:CustomerRequired
Notes: {SO5$(608,30)}
23 ShipToCity. . . . . . . . . . 20 SNN Ship-To City. . . . . . . . . .CITY
ValGroup:CustomerRequired
Notes: {SO5$(247,20)}
24 ShipToState . . . . . . . . . 2 SYN Ship-To State . . . . . . . . .STATE
ValGroup:CustomerRequired
Notes: {SO5$(267,2)}
25 ShipToZipCode . . . . . . . . 10 SYN Ship-To Zip Code. . . . . . . .ZIPCODE
ValGroup:CustomerRequired
Notes: {SO5$(269,10)}
26 ShipToCountryCode . . . . . . 3 SYN Ship-To Country Code. . . . . .COUNTRY
ValGroup:CustomerRequired
Notes: {SO5$(638,3)}
27 ShipDate. . . . . . . . . . . 8 SNN Ship Date . . . . . . . . . . .DATE
Notes: {SO5$(280,6)}
28 ShipVia . . . . . . . . . . . 15 SYN Ship Via. . . . . . . . . . . .SHIPCODE
Notes: {SO5$(301,15)}
29 ShipZone. . . . . . . . . . . 5 SYN Ship Zone . . . . . . . . . . .SHIPZONE
ValGroup:CustomerRequired
Notes: (Maintained)
{SO5$(444,5)}
30 ShipZoneActual. . . . . . . . 5 SYN Ship Zone Actual. . . . . . . .
ValGroup:CustomerRequired
Notes: (Inverse If Shp As
Zip) {SO5$(454,5)}
31 ShipWeight. . . . . . . . . . 5 SYN Ship Weight . . . . . . . . . .SHIPWEIGHT
Mask:00000 FmtType:CHARNUM
ValGroup:CustomerRequired
Notes: {SO5$(449,5)}
32 CustomerPONo. . . . . . . . . 15 SNN Customer PO Number. . . . . . .CUSTOMERPONO
ValGroup:CustomerRequired
Notes: {SO5$(286,15)}
33 FOB . . . . . . . . . . . . . 15 SNN F.O.B.. . . . . . . . . . . . .
Notes: {SO5$(316,15)}
34 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE
FmtType:CHARNUM DepVal:REQUIR
ED ValGroup:MultiWarehouse
Notes: {SO5$(331,3)}
35 ConfirmTo . . . . . . . . . . 30 SNN Confirm To. . . . . . . . . . .
Notes: {SO5$(334,30)}
36 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . .COMMENT30
Notes: {SO5$(364,30)}
37 TaxSchedule . . . . . . . . . 9 SYN Tax Schedule. . . . . . . . . .TAXSCHEDULE
FmtType:CHARNUM DepVal:REQUIR
ED ValGroup:ARSalesTax
Notes: {SO5$(394,9)}
38 TermsCode . . . . . . . . . . 2 SNN Terms Code. . . . . . . . . . .ARTERMS
DfltVal:00 Mask:00 FmtType:ZE
ROFILL DepVal:REQUIRED
Notes: {SO5$(403,2)}
39 TaxExemptNo . . . . . . . . . 15 SNN Tax Exempt Number . . . . . . .
Notes: (Only If Sales Tax
Reporting = Yes) {SO5$(409,
15)}
40 PrintInvoice. . . . . . . . . 1 SYN Print Invoice . . . . . . . . .YESNO
DfltVal:N Valid:Y,N
ValGroup:CustomerRequired
Notes: {SO5$(424,1)}
41 InvoicePrinted. . . . . . . . 1 SYN Invoice Printed . . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{SO5$(429,1)}
42 AcceptCashOnly. . . . . . . . 1 SYN Accept Cash Only. . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{SO5$(427,1)}
43 CustomerType. . . . . . . . . 4 SYN Customer Type . . . . . . . . .
ValGroup:CustomerRequired
Notes: (From Update)
{SO5$(436,4)}
44 ResidentialAddress. . . . . . 1 SYN Residential Address . . . . . .YESNO
DfltVal:N Valid:Y,N
45 InvalidTaxCalc. . . . . . . . 1 SYN Invalid Tax Calculation . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{SO5$(440,1)}
46 FreightCalculationMethod. . . 1 SYN Freight Calculation Method. . .
Valid:A,P,W Notes: A=Actual,
P=Percent, W=Weight
{SO5$(442,1)}
47 CheckNoForDeposit . . . . . . 10 SNN Check Number For Deposit. . . .CHECKNO
FmtType:CHARNUM DepVal:REQUIR
ED Notes: {SO5$(464,6)}
48 ApplyToInvoiceNo. . . . . . . 7 SYN Apply To Invoice Number . . . .
FmtType:CHARNUM ValGroup:Cust
omerRequired Notes: (For CM
& Dm Types) {SO5$(470,7)}
49 LotSerialLinesExist . . . . . 1 SYN Lot/Serial Lines Exist. . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{SO5$(477,1)}
50 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . .ARDIVISION
Mask:00 FmtType:ZEROFILL
ValGroup:CustomerRequired,
SalespersonReporting
51 SalespersonNo . . . . . . . . 4 SYN Salesperson Number. . . . . . .SALESPERSONNO
FmtType:CHARNUM ValGroup:Sale
spersonReporting Notes:
{SO5$(405,4)}
52 SplitCommissions. . . . . . . 1 SYN Split Commissions . . . . . . .
DfltVal:N Valid:Y,N,O
ValGroup:SplitCommission,
SalespersonRequired Notes:
Y=Yes, N=No, O=Override
{SO5$(478,1)}
53 SalespersonDivisionNo2. . . . 2 SNN Salesperson Division Number 2 .ARDIVISION
Mask:00 FmtType:ZEROFILL
ValGroup:SplitCommission,
SalespersonRequired Notes:
{SO5$(479,2)}
54 SalespersonNo2. . . . . . . . 4 SYN Salesperson Number 2. . . . . .SALESPERSONNO
FmtType:CHARNUM DepVal:REQUIR
ED ValGroup:SplitCommission,
SalespersonRequired Notes:
{SO5$(481,4)}
55 SalespersonDivisionNo3. . . . 2 SNN Salesperson Division Number 3 .ARDIVISION
Mask:00 FmtType:ZEROFILL
ValGroup:SplitCommission,
SalespersonRequired Notes:
{SO5$(492,2)}
56 SalespersonNo3. . . . . . . . 4 SYN Salesperson Number 3. . . . . .SALESPERSONNO
FmtType:CHARNUM DepVal:REQUIR
ED ValGroup:SplitCommission,
SalespersonRequired Notes:
{SO5$(494,4)}
57 SalespersonDivisionNo4. . . . 2 SNN Salesperson Division Number 4 .ARDIVISION
Mask:00 FmtType:ZEROFILL
ValGroup:SplitCommission,
SalespersonRequired Notes:
{SO5$(505,2)}
58 SalespersonNo4. . . . . . . . 4 SYN Salesperson Number 4. . . . . .SALESPERSONNO
FmtType:CHARNUM DepVal:REQUIR
ED ValGroup:SplitCommission,
SalespersonRequired Notes:
{SO5$(507,4)}
59 SalespersonDivisionNo5. . . . 2 SNN Salesperson Division Number 5 .ARDIVISION
Mask:00 FmtType:ZEROFILL
ValGroup:SplitCommission,
SalespersonRequired Notes:
{SO5$(518,2)}
60 SalespersonNo5. . . . . . . . 4 SYN Salesperson Number 5. . . . . .SALESPERSONNO
FmtType:CHARNUM DepVal:REQUIR
ED ValGroup:SplitCommission,
SalespersonRequired Notes:
{SO5$(520,4)}
61 InvoiceDueDate. . . . . . . . 8 SNN Invoice Due Date. . . . . . . .DATE
Notes: {SO5$(531,6)}
62 DiscountDueDate . . . . . . . 8 SNN Discount Due Date . . . . . . .DATE
Notes: {SO5$(537,6)}
63 BatchNo . . . . . . . . . . . 5 SYN Batch Number. . . . . . . . . .BATCHNO
FmtType:ALPHANUM Notes:
{SO5$(553,5)}
64 EBMSubmissionType . . . . . . 1 SYN e-Business Manager Submission T
Read Only:Y Valid:M,A Notes:
M=Manual, A=Auto {SO5$(591,
1)}
65 EBMUserIDSubmittingThisOrder. 15 SYN e-Business Manager User ID Subm
Read Only:Y Notes: {SO5$(592,
15)}
66 EBMUserType . . . . . . . . . 1 SYN e-Business Manager User Type. .
Read Only:Y Valid:1,2 Notes:
1=bus., 2=consumer {SO5$(443,
1)}
67 EMailUpdateFlagForRestart . . 1 SYN E-Mail Update Flag for Restart.
Notes: {SO5$(607,1)}
68 FaxNo . . . . . . . . . . . . 17 SNN Fax Number. . . . . . . . . . .TELEPHONENO
DepVal:REQUIRED Notes:
{SO5$(641,17)}
69 BatchFax. . . . . . . . . . . 1 SYN Batch Fax . . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{SO5$(441,1)}
70 BatchEmail. . . . . . . . . . 1 SYN Batch Email . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N
71 EmailAddress. . . . . . . . . 250 SNN Email Address . . . . . . . . .EMAILADDRESS
72 PaymentType . . . . . . . . . 5 SYN Payment Type. . . . . . . . . .PAYMENTTYPE
DepVal:REQUIRED Notes:
{SO5$(658,5)}
73 PaymentTypeCategory . . . . . 1 SYN Payment Type Category . . . . .
DfltVal:D Valid:P,D Notes:
P=Payment, D=Deposit
{SO5$(836,1)}
74 OtherPaymentTypeRefNo . . . . 24 SNN Other Payment Type Reference Nu
DepVal:REQUIRED Notes:
{SO5$(663,24)}
75 CorporateCustIDPurchOrder . . 25 SNN Corporate Customer ID / Purchas
76 CorporateTaxOverrd. . . . . . 1 SYY Corporate Tax Overridden. . . .YESNO
DfltVal:N Valid:Y,N
77 DepositCorporateTaxOverrd . . 1 SYY Deposit Corporate Tax OverriddeYESNO
DfltVal:N Valid:Y,N
78 CardholderName. . . . . . . . 30 SNN Cardholder Name . . . . . . . .NAME
Notes: {SO5$(687,30)}
79 ExpirationDateYear. . . . . . 4 SNN Expiration Date Year. . . . . .YEAR
Mask:0000 Notes: {SO5$(717,
2)}
80 ExpirationDateMonth . . . . . 2 SNN Expiration Date Month . . . . .MONTH
Mask:00 FmtType:ZEROFILL
Notes: {SO5$(719,2)}
81 EncryptedCreditCardNo . . . . 24 SNN Encrypted Credit Card Number. .ENCRYPTEDCREDITCARDNO
Notes: {SO5$(739,24)}
82 CreditCardCVV2No. . . . . . . 5 SNN Credit Card CVV2 Number . . . .
Notes: {SO5$(763,4)}
83 Last4UnencryptedCreditCardNos 4 SNN Last 4 Unencrypted Credit Card
Notes: {SO5$(767,4)}
84 CreditCardAuthorizationNo . . 16 SNN Credit Card Authorization Numbe
Notes: {SO5$(771,16)}
85 AuthorizationCodeForDeposit . 16 SNN Authorization Code For Deposit.
DepVal:REQUIRED Notes:
{SO5$(810,16)}
86 AuthorizationDate . . . . . . 8 SNN Authorization Date. . . . . . .DATE
DepVal:REQUIRED Notes:
{SO5$(797,6)}
87 AuthorizationTime . . . . . . 6 SNN Authorization Time. . . . . . .
DepVal:REQUIRED Notes:
{SO5$(803,6)}
88 PostAuthorizationProcessed. . 1 SYN Post Authorization Processed. .YESNO
DfltVal:N Valid:Y,N Notes:
{SO5$(809,1)}
89 CreditCardTransactionID . . . 10 SNN Credit Card Transaction ID. . .
Notes: {SO5$(787,10)}
90 CreditCardTransactionIDForDep 10 SNN Credit Card Transaction ID for
Notes: {SO5$(826,10)}
91 CreditCardComment . . . . . . 30 SNN Credit Card Comment . . . . . .
Notes: {SO5$(921,30)}
92 PayBalanceByCreditCard. . . . 1 SYN Pay Balance By Credit Card. . .YESNO
DfltVal:N Valid:Y,N Notes:
{SO5$(837,1)}
93 OrderChangedInShipping. . . . 1 SYN Order Changed In Shipping . . .YESNO
DfltVal:N Valid:Y,N Notes:
{SO5$(838,1)}
94 LinesChangedInShipping. . . . 1 SYN Lines Changed In Shipping . . .YESNO
DfltVal:N Valid:Y,N Notes:
{SO5$(839,1)}
95 ShipperID . . . . . . . . . . 3 SYN Shipper ID. . . . . . . . . . .SHIPPERID
Notes: {SO5$(848,3)}
96 ShipStatus. . . . . . . . . . 1 SYN Ship Status . . . . . . . . . .
Valid:N,L,S,D Notes: N=New,
L=Lines completed, S=Shipped,
D=Deleted {SO5$(852,1)}
97 StarshipFreightUsed . . . . . 1 SYN Starship Freight Used . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{SO5$(857,1)}
98 StarshipRecordsCreated. . . . 1 SYN Starship Records Created. . . .YESNO
DfltVal:N Valid:Y,N Notes:
{SO5$(858,1)}
99 AVSAddress. . . . . . . . . . 30 SNN AVS Address . . . . . . . . . .ADDRESSLINE
Notes: {SO5$(859,30)}
100 AVSCity . . . . . . . . . . . 20 SNN AVS City. . . . . . . . . . . .CITY
Notes: {SO5$(889,20)}
101 AVSState. . . . . . . . . . . 2 SYN AVS State . . . . . . . . . . .STATE
Notes: {SO5$(909,2)}
102 AVSZipCode. . . . . . . . . . 10 SYN AVS Zip Code. . . . . . . . . .ZIPCODE
Notes: {SO5$(911,10)}
103 JobNo . . . . . . . . . . . . 7 SYN Job Number. . . . . . . . . . .JOBNO
FmtType:CHARNUM DepVal:REQUIR
ED ValGroup:JCIntegrated,
CustomerRequired
104 RMANo . . . . . . . . . . . . 7 SYN RMA Number. . . . . . . . . . .RMANO
FmtType:CHARNUM Notes:
{SO5$(721,7)}
105 CRMUserID . . . . . . . . . . 11 SNN CRM User ID . . . . . . . . . .
Read Only:Y ValGroup:CU_Integ
rated
106 CRMCompanyID. . . . . . . . . 11 SNN CRM Company ID. . . . . . . . .
Read Only:Y ValGroup:CU_Integ
rated
107 CRMPersonID . . . . . . . . . 11 SNN CRM Person ID . . . . . . . . .
Read Only:Y ValGroup:CU_Integ
rated
108 CRMOpportunityID. . . . . . . 11 SNN CRM Opportunity ID. . . . . . .
Read Only:Y ValGroup:CU_Integ
rated
109 InvalidWarrantyCode . . . . . 1 SYN Invalid Warranty Code . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
Set at Pre-Update {SO5$(728,
1)}
110 TaxableSubjectToDiscount. . . 13.2 NNN Taxable Subject To Discount . .AMOUNT
Read Only:Y Mask:###,###,
###.00 Notes: {SO5[1]}
111 NonTaxableSubjectToDiscount . 13.2 NNN Non-Taxable Subject To DiscountAMOUNT
Read Only:Y Mask:###,###,
###.00 Notes: {SO5[2]}
112 TaxSubjToDiscPrcntOfTotSubjTo 8.2 NNN Tax SubjectTo Disc % Of Total S
Read Only:Y Mask:#,###.00-
Notes: {SO5[3]}
113 DiscountRate. . . . . . . . . 9.3 NNN Discount Rate . . . . . . . . .
Mask:#,###.000 ValGroup:Custo
merRequired Notes: {SO5[4]}
114 TaxableAmt. . . . . . . . . . 13.2 NNN Taxable Amount. . . . . . . . .AMOUNT
Read Only:Y Mask:###,###,
###.00 ValGroup:CustomerRequi
red Notes: {SO5[6]}
115 NonTaxableAmt . . . . . . . . 13.2 NNN Non-Taxable Amount. . . . . . .AMOUNT
Read Only:Y Mask:###,###,
###.00 ValGroup:CustomerRequi
red Notes: {SO5[7]}
116 SalesTaxAmt . . . . . . . . . 12.2 NNN Sales Tax Amount. . . . . . . .MISCAMOUNT
Mask:##,###,###.00-
ValGroup:CustomerRequired,
ARSalesTax ValSeqNo:9999
Notes: {SO5[8]}
117 DiscountAmt . . . . . . . . . 12.2 NNN Discount Amount . . . . . . . .MISCAMOUNT
Mask:##,###,###.00-
ValGroup:CustomerRequired
ValSeqNo:9999 Notes: {SO5[5]}
118 RetentionAmt. . . . . . . . . 13.2 NNN Retention Amount. . . . . . . .
Mask:###,###,###.00
119 TotalSubjectToComm. . . . . . 13.2 NNN Total Subject To Commission . .AMOUNT
Mask:###,###,###.00
ValGroup:CustomerRequired
Notes: (Calc @ Pre-Update)
{SO5[9]}
120 CommissionRate. . . . . . . . 9.3 NNN Commission Rate . . . . . . . .COMMISSIONRATE
Mask:###0.000 ValGroup:Custom
erRequired,SalespersonReporti
ng,SalespersonRequired
Notes: {SO5[10]}
121 CommissionAmt . . . . . . . . 12.2 NNN Commission Amount . . . . . . .MISCAMOUNT
Mask:##,###,###.00- Notes:
(Calc @ Pre-Update) {SO5[11]}
122 SplitCommRate2. . . . . . . . 9.3 NNN Split Commission Rate 2 . . . .
Mask:###0.000 ValGroup:SplitC
ommission,SalespersonRequired
Notes: {SO5$(485,7)}
123 SplitCommRate3. . . . . . . . 9.3 NNN Split Commission Rate 3 . . . .
Mask:###0.000 ValGroup:SplitC
ommission,SalespersonRequired
Notes: {SO5$(498,7)}
124 SplitCommRate4. . . . . . . . 9.3 NNN Split Commission Rate 4 . . . .
Mask:###0.000 ValGroup:SplitC
ommission,SalespersonRequired
Notes: {SO5$(511,7)}
125 SplitCommRate5. . . . . . . . 9.3 NNN Split Commission Rate 5 . . . .
Mask:###0.000 ValGroup:SplitC
ommission,SalespersonRequired
Notes: {SO5$(524,7)}
126 OverrideCommAmt . . . . . . . 12.2 NNN Override Commission Amount. . .
Mask:##,###,###.00- Notes:
Calc@Pre-Update {SO5$(543,
10)}
127 FreightAmt. . . . . . . . . . 12.2 NNN Freight Amount. . . . . . . . .
Mask:##,###,###.00-
ValSeqNo:9999 Notes:
{SO5[12]}
128 CostOfGoodsSoldAmt. . . . . . 13.2 NNN Cost Of Goods Sold Amount. . .
Mask:###,###,###.00- Notes:
(Calc @ Pre-Update) {SO5[13]}
129 CostOfGoodsSoldSubjToComm . . 13.2 NNN Cost of Goods Sold Subject To C
Mask:###,###,###.00- Notes:
Calc @ Pre-Update) {SO5[14]}
130 DepositAmt. . . . . . . . . . 13.2 NNN Deposit Amount. . . . . . . . .
Mask:###,###,###.00-
ValSeqNo:9999 Notes:
{SO5[15]}
131 Weight. . . . . . . . . . . . 12.2 NNN Weight. . . . . . . . . . . . .
Mask:##,###,###.00- Notes:
{SO5[16]}
132 CreditCardPreAuthorizationAmt 13.2 NNN Credit Card Pre-Authorization A
Mask:###,###,###.00- Notes:
{SO5[17]}
133 CreditCardPaymentBalanceAmt . 13.2 NNN Credit Card Payment / Balance A
Mask:###,###,###.00- Notes:
{SO5[18]}
134 SIShippedLinesCOGS. . . . . . 13.2 NNN SI Shipped Lines COGS . . . . .
Mask:###,###,###.00- Notes:
{SO5[19]}
135 NumberOfCODLabels . . . . . . 2.0 NNN Number Of C.O.D. Labels . . . .
Mask:00 Notes: {SO5$(425,2)}
136 NumberOfBackOrderLines. . . . 5.0 NNN Number Of Backordered Lines . .
Mask:00000 Notes: (From
Update) {SO5$(459,5)}
137 NumberOfShippingLabels. . . . 4.0 NNN Number of Shipping Labels . . .
Mask:0000 Notes: {SO5$(840,
4)}
138 LastNoOfShippingLabels. . . . 4.0 NNN Last Number of Shipping Labels.
Mask:0000 Notes: {SO5$(844,
4)}
139 NumberofPackages. . . . . . . 4.0 NNN Number of Packages. . . . . . .
Mask:0000 Notes: {SO5$(853,
4)}
140 DepositCorporateSalesTax. . . 12.2 NNN Deposit Corporate Sales Tax . .MISCAMOUNT
Mask:##,###,###.00-
141 CorporateSalesTax . . . . . . 12.2 NNN Corporate Sales Tax . . . . . .MISCAMOUNT
Mask:##,###,###.00-
142 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
143 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . .
Read Only:Y
144 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL
145 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
146 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y
147 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL