AR_InvoiceHistoryDetail AR Invoice History Detail Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: AR_InvoiceHistoryInquiryDetail_bus,SO_SalesJournal_upd,AR_SalesJournal_upd
SQL Def: N SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_InvoiceHistoryDetail.M4T"
KPRIMARY: InvoiceNo+HeaderSeqNo+DetailSeqNo
KEXTENDEDDESC: ExtendedDescriptionKey+InvoiceNo+HeaderSeqNo+DetailSeqNo
Fld Column Name M/L TUR Description/Notes Class
1 InvoiceNo . . . . . . . . . . 7 SYY Invoice Number. . . . . . . . .INVOICE
FmtType:MASTERNUM Notes:
{ARO$(1,7)}
2 HeaderSeqNo . . . . . . . . . 6 SNY Header Sequence Number. . . . .
Mask:000000 FmtType:ZEROFILL
Notes: {ARO$(8,3)}
3 DetailSeqNo . . . . . . . . . 6 SNY Detail Sequence Number. . . . .
Mask:000000 FmtType:ZEROFILL
Notes: {ARO$(11,5)}
4 ItemCode. . . . . . . . . . . 30 SYY Item Code . . . . . . . . . . .ITEMCODE
ChngTag:Replace0 Notes:
{ARO$(20,6)}
5 ItemType. . . . . . . . . . . 1 SYY Item Type . . . . . . . . . . .
Valid:1,2,3,4,5 Notes:
1=Inventory Item, 2=Special
Item, 3=Charge Item,
4=Comment Item, 5=Miscellaneo
us Item {ARO$(19,1)}
6 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . .DESCRIPTION
Notes: {ARO$(26,30)}
7 ExtendedDescriptionKey. . . . 10 SYN Extended Description Key. . . .EXTDESCKEY
Read Only:Y Notes: {ARO$(135,
1)}
8 SalesAcctKey. . . . . . . . . 9 SYN Sales Account Key . . . . . . .ACCOUNT
Notes: {ARO$(56,9)}
9 CostOfGoodsSoldAcctKey. . . . 9 SYN Cost of Goods Sold Account Key.ACCOUNT
Notes: {ARO$(65,9)}
10 InventoryAcctKey. . . . . . . 9 SYN Inventory Account Key . . . . .ACCOUNT
Notes: {ARO$(74,9)}
11 UnitOfMeasure . . . . . . . . 4 SYN Unit Of Measure . . . . . . . .UNITOFMEASURE
Notes: {ARO$(83,4)}
12 SubjectToExemption. . . . . . 1 SYN Subject To Exemption. . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{ARO$(87,1)}
13 Commissionable. . . . . . . . 1 SYN Commissionable. . . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{ARO$(88,1)}
14 TaxClass. . . . . . . . . . . 2 SYN Tax Class . . . . . . . . . . .TAXCLASS
Notes: {ARO$(89,2)}
15 Discount. . . . . . . . . . . 1 SYY Discount. . . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{ARO$(40,1)}
16 DropShip. . . . . . . . . . . 1 SYY Drop Ship . . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{ARO$(84,1)}
17 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE
FmtType:CHARNUM Notes:
{ARO$(103,3)}
18 PriceLevel. . . . . . . . . . 1 SYN Price Level . . . . . . . . . .
Notes: {ARO$(106,1)}
19 ProductLine . . . . . . . . . 4 SYN Product Line. . . . . . . . . .PRODUCTLINE
FmtType:CHARNUM Notes:
{ARO$(108,4)}
20 Valuation . . . . . . . . . . 1 SNN Valuation . . . . . . . . . . .
Valid:1,2,3,4,5,6 Notes:
1=Standard, 2=Average,
3=Fifo, 4=Lifo, 5=Lot,
6=Serial
21 PriceOverridden . . . . . . . 1 SYN Price Overridden. . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{ARO$(112,1)}
22 OrderWarehouse. . . . . . . . 3 SYN Order Warehouse . . . . . . . .WAREHOUSE
FmtType:CHARNUM Notes:
{ARO$(113,3)}
23 Revision. . . . . . . . . . . 3 SNN Bill Revision Code. . . . . . .
24 BillOption1 . . . . . . . . . 2 SYN Bill Option 1 . . . . . . . . .BILLOPTION
FmtType:CHARNUM Notes:
{ARO$(117,2)}
25 BillOption2 . . . . . . . . . 2 SYN Bill Option 2 . . . . . . . . .BILLOPTION
FmtType:CHARNUM Notes:
{ARO$(119,2)}
26 BillOption3 . . . . . . . . . 2 SYN Bill Option 3 . . . . . . . . .BILLOPTION
FmtType:CHARNUM Notes:
{ARO$(121,2)}
27 BillOption4 . . . . . . . . . 2 SYN Bill Option 4 . . . . . . . . .BILLOPTION
FmtType:CHARNUM Notes:
{ARO$(123,2)}
28 BillOption5 . . . . . . . . . 2 SYN Bill Option 5 . . . . . . . . .BILLOPTION
FmtType:CHARNUM Notes:
{ARO$(125,2)}
29 BillOption6 . . . . . . . . . 2 SYN Bill Option 6 . . . . . . . . .BILLOPTION
FmtType:CHARNUM Notes:
{ARO$(127,2)}
30 BillOption7 . . . . . . . . . 2 SYN Bill Option 7 . . . . . . . . .BILLOPTION
FmtType:CHARNUM Notes:
{ARO$(129,2)}
31 BillOption8 . . . . . . . . . 2 SYN Bill Option 8 . . . . . . . . .BILLOPTION
FmtType:CHARNUM Notes:
{ARO$(131,2)}
32 BillOption9 . . . . . . . . . 2 SYN Bill Option 9 . . . . . . . . .BILLOPTION
FmtType:CHARNUM Notes:
{ARO$(133,2)}
33 KitItem . . . . . . . . . . . 1 SYY Kit Item. . . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{ARO$(116,1)}
34 ExplodedKitItem . . . . . . . 1 SYN Exploded Kit Item . . . . . . .
DfltVal:N Valid:Y,N,C Notes:
Y=Yes, N=No, C=Component
{ARO$(145,1)}
35 SkipPrintCompLine . . . . . . 1 SYY Skip Print Of Component Lines .YESNO
DfltVal:N Valid:Y,N Notes:
{ARO$(147,1)}
36 StandardKitBill . . . . . . . 1 SYY Standard Kit Bill . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{ARO$(146,1)}
37 AliasItemNo . . . . . . . . . 30 SYN Alias Item Number . . . . . . .
Notes: {ARO$(158,30)}
38 CustomerAction. . . . . . . . 1 SYN Customer Action . . . . . . . .
DfltVal:N Valid:C,P,R,N
Notes: C=Credit, P=rePlacemen
t, R=Repair, N=None
{ARO$(188,1)}
39 ItemAction. . . . . . . . . . 1 SYN Item Action . . . . . . . . . .
DfltVal:N Valid:S,P,R,N
Notes: S=Stock, P=scraP,
R=Repair, N=None
40 WarrantyCode. . . . . . . . . 10 SYN Warranty Code . . . . . . . . .WARRANTYCODE
Notes: {ARO$(189,10)}
41 ExpirationDate. . . . . . . . 8 SNN Expiration Date . . . . . . . .DATE
Notes: {ARO$(199,6)}
42 ExpirationOverridden. . . . . 1 SYY Expiration Overridden . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{ARO$(205,1)}
43 CostCode. . . . . . . . . . . 9 SYN Cost Code . . . . . . . . . . .COSTCODE
FmtType:CHARNUM
44 CostType. . . . . . . . . . . 1 SYN Cost Type . . . . . . . . . . .COSTTYPE
Notes: {ARO$(107,1)}
45 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . .COMMENT
Notes: {ARO$(40,100)}
46 PromiseDate . . . . . . . . . 8 SNN Promise Date. . . . . . . . . .DATE
47 QuantityShipped . . . . . . . 16.6 NNN Quantity Shipped. . . . . . . .QUANTITY
Mask:##,###,###.000000-
Notes: {ARO[1]}
48 QuantityOrdered . . . . . . . 16.6 NNN Quantity Ordered. . . . . . . .QUANTITY
Mask:##,###,###.000000-
Notes: {ARO[0]}
49 QuantityBackordered . . . . . 16.6 NNN Quantity Backordered. . . . . .QUANTITY
Mask:##,###,###.000000-
Notes: {ARO[2]}
50 UnitPrice . . . . . . . . . . 16.6 NNN Unit Price. . . . . . . . . . .PRICE
Mask:##,###,###.000000-
Notes: {ARO[1]}
51 UnitCost. . . . . . . . . . . 16.6 NNN Unit Cost . . . . . . . . . . .COST
Mask:##,###,###.000000-
Notes: {ARO[2]}
52 UnitOfMeasureConvFactor . . . 12.4 NNN Unit Of Measure Conversion FactUMCONVFACTOR
Mask:#####0.0000 Notes:
{ARO[6]}
53 CommissionAmt . . . . . . . . 13.2 NNN Commission Amount . . . . . . .AMOUNT
Mask:###,###,###.00 Notes:
{ARO[7]}
54 LineDiscountPercent . . . . . 9.3 NNN Line Discount Percent . . . . .
Mask:###0.000 Notes:
{ARO$(73,7)}
55 QuantityPerBill . . . . . . . 16.6 NNN Quantity Per Bill . . . . . . .QUANTITY
Mask:##,###,###.000000-
Notes: {ARO$(148,10)}
56 ExtensionAmt. . . . . . . . . 12.2 NNN Extension Amount. . . . . . . .
Mask:##,###,###.00 Notes:
{ARO[3]}