SO_InvoiceDetail SO Invoice Detail Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: SO_InvoiceDetail_bus,RA_GenerateTransactions_upd,BC_CommonImport
SQL Def: N SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_InvoiceDetail.M4T"
KPRIMARY: InvoiceNo+LineKey
KDISPLAY: InvoiceNo+LineSeqNo+LineKey
KEXTENDEDDESC: ExtendedDescriptionKey+InvoiceNo+LineKey
KITEM: ItemCode+InvoiceNo+LineKey
KITEMWHSE: ItemCode+WarehouseCode+InvoiceNo+LineKey
Fld Column Name M/L TUR Description/Notes Class
1 InvoiceNo . . . . . . . . . . 7 SYY Invoice Number. . . . . . . . .INVOICE
Read Only:Y FmtType:MASTERNUM
2 LineKey . . . . . . . . . . . 6 SNY Line Key. . . . . . . . . . . .
Read Only:Y Mask:000000
FmtType:ZEROFILL
3 LineSeqNo . . . . . . . . . . 14 SNY Line Sequence Number. . . . . .
Read Only:Y Mask:000000000000
00 FmtType:ZEROFILL
4 ItemCode. . . . . . . . . . . 30 SYY Item Code . . . . . . . . . . .ITEMCODE
5 ItemType. . . . . . . . . . . 1 SYY Item Type . . . . . . . . . . .
Valid:1,2,3,4,5 Notes:
1=Regular Item, 2=Special
Item, 3=Charge Item,
4=Comment Item, 5=Miscellaneo
us Item
6 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . .DESCRIPTION
ValGroup:NotComment,
ItemRequired
7 ExtendedDescriptionKey. . . . 10 SNN Extended Description Key. . . .EXTDESCKEY
Read Only:Y ValGroup:NotComme
nt,ItemRequired
8 Discount. . . . . . . . . . . 1 SYN Discount. . . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N
ValGroup:NotComment,
ItemRequired,NotComponent
9 Commissionable. . . . . . . . 1 SYN Commissionable. . . . . . . . .YESNO
DfltVal:N Valid:Y,N
ValGroup:NotComment,
SalespersonReporting,
NotComponent
10 SubjectToExemption. . . . . . 1 SYN Subject To Exemption. . . . . .YESNO
DfltVal:N Valid:Y,N
ValGroup:NotComment
11 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE
FmtType:CHARNUM DepVal:REQUIR
ED ValGroup:IMIntegrated,
NotComment,MultiWarehouse,
ItemRequired,RegularItem,
NotNulWarehouseCode
12 ProductLine . . . . . . . . . 4 SYN Product Line. . . . . . . . . .PRODUCTLINE
FmtType:CHARNUM ValGroup:NotC
omment
13 Valuation . . . . . . . . . . 1 SYN Valuation . . . . . . . . . . .
Valid:1,2,3,4,5,6 ValGroup:No
tComment Notes: 1=Standard,
2=Average, 3=Fifo, 4=Lifo,
5=Lot, 6=Serial
14 PriceLevel. . . . . . . . . . 1 SYN Price Level . . . . . . . . . .
DepVal:REQUIRED ValGroup:IMIn
tegrated,NotComment,
ItemRequired,RegularItem,
NotComponent
15 UnitOfMeasure . . . . . . . . 4 SYN Unit Of Measure . . . . . . . .UNITOFMEASURE
ValGroup:NotComment,
ItemRequired,ItemTypes
16 DropShip. . . . . . . . . . . 1 SYN Drop Ship . . . . . . . . . . .YESNO
DfltVal:N ValGroup:NotComment
,ItemTypes
17 LotSerialFullyDistributed . . 1 SYN Lot/Serial Fully Distributed. .YESNO
DfltVal:Y Valid:Y,N
ValGroup:NotComment
18 SalesKitLineKey . . . . . . . 6 SNN Sales Kit Line Key. . . . . . .
Mask:000000 FmtType:ZEROFILL
ValGroup:NotComment
19 CostOfGoodsSoldAcctKey. . . . 9 SYN Cost of Goods Sold Account Key.ACCOUNT
DepVal:REQUIRED ValGroup:NotC
omment,ItemRequired,
ItemTypes
20 SalesAcctKey. . . . . . . . . 9 SYN Sales Account Key . . . . . . .ACCOUNT
DepVal:REQUIRED ValGroup:NotC
omment,ItemRequired
21 PriceOverridden . . . . . . . 1 SYN Price Overridden. . . . . . . .YESNO
DfltVal:N Valid:Y,N
ValGroup:NotComment
22 OrderWarehouse. . . . . . . . 3 SYN Order Warehouse . . . . . . . .
FmtType:CHARNUM ValGroup:NotC
omment
23 ExplodedKitItem . . . . . . . 1 SYN Exploded Kit Item . . . . . . .YESNO
DfltVal:N Valid:Y,N
ValGroup:NotComment
24 OrderLineKey. . . . . . . . . 6 SNN Order Line Key. . . . . . . . .
Mask:000000 FmtType:ZEROFILL
ValGroup:NotComment
25 Revision. . . . . . . . . . . 3 SNN Bill Revision Code. . . . . . .
26 BillOption1 . . . . . . . . . 2 SYN Bill Option 1 . . . . . . . . .BILLOPTION
FmtType:CHARNUM DepVal:REQUIR
ED ValGroup:BMIntegrated,
NotComment,BillHasOptions,
ItemRequired,RegularItem
27 BillOption2 . . . . . . . . . 2 SYN Bill Option 2 . . . . . . . . .BILLOPTION
FmtType:CHARNUM DepVal:REQUIR
ED ValGroup:BMIntegrated,
NotComment,BillHasOptions,
ItemRequired,RegularItem
28 BillOption3 . . . . . . . . . 2 SYN Bill Option 3 . . . . . . . . .BILLOPTION
FmtType:CHARNUM DepVal:REQUIR
ED ValGroup:BMIntegrated,
NotComment,BillHasOptions,
ItemRequired,RegularItem
29 BillOption4 . . . . . . . . . 2 SYN Bill Option 4 . . . . . . . . .BILLOPTION
FmtType:CHARNUM DepVal:REQUIR
ED ValGroup:BMIntegrated,
NotComment,BillHasOptions,
ItemRequired,RegularItem
30 BillOption5 . . . . . . . . . 2 SYN Bill Option 5 . . . . . . . . .BILLOPTION
FmtType:CHARNUM DepVal:REQUIR
ED ValGroup:BMIntegrated,
NotComment,BillHasOptions,
ItemRequired,RegularItem
31 BillOption6 . . . . . . . . . 2 SYN Bill Option 6 . . . . . . . . .BILLOPTION
FmtType:CHARNUM DepVal:REQUIR
ED ValGroup:BMIntegrated,
NotComment,BillHasOptions,
ItemRequired,RegularItem
32 BillOption7 . . . . . . . . . 2 SYN Bill Option 7 . . . . . . . . .BILLOPTION
FmtType:CHARNUM DepVal:REQUIR
ED ValGroup:BMIntegrated,
NotComment,BillHasOptions,
ItemRequired,RegularItem
33 BillOption8 . . . . . . . . . 2 SYN Bill Option 8 . . . . . . . . .BILLOPTION
FmtType:CHARNUM DepVal:REQUIR
ED ValGroup:BMIntegrated,
NotComment,BillHasOptions,
ItemRequired,RegularItem
34 BillOption9 . . . . . . . . . 2 SYN Bill Option 9 . . . . . . . . .BILLOPTION
FmtType:CHARNUM DepVal:REQUIR
ED ValGroup:BMIntegrated,
NotComment,BillHasOptions,
ItemRequired,RegularItem
35 BackorderKitCompLine. . . . . 1 SYN Backorder Kit Component Line. .YESNO
DfltVal:N Valid:Y,N
ValGroup:NotComment Notes:
Kit Bckord=0, Comp Bckord>0
Flg=Y
36 StandardKitBill . . . . . . . 1 SYN Standard/Kit Bill . . . . . . .YESNO
DfltVal:N Valid:Y,N
ValGroup:NotComment
37 SkipPrintCompLine . . . . . . 1 SYN Skip Print Of Component Line inYESNO
DfltVal:N Valid:Y,N
ValGroup:NotComment
38 AliasItemNo . . . . . . . . . 30 SYN Alias Item Number . . . . . . .
ValGroup:NotComment,
ItemRequired,RegularItem
39 TaxClass. . . . . . . . . . . 2 SYN Tax Class . . . . . . . . . . .TAXCLASS
ValGroup:NotComment
40 SOHistoryDetlSeqNo. . . . . . 14 SNN Sales Order History Detail Sequ
Mask:00000000000000
FmtType:ZEROFILL ValGroup:Not
Comment
41 CustomerAction. . . . . . . . 1 SYN Customer Action . . . . . . . .
DfltVal:N Valid:N,C,P,R
ValGroup:NotComment Notes:
N=None, C=Credit, P=rePlaceme
nt, R=Repair
42 WarrantyCode. . . . . . . . . 10 SYN Warranty Code . . . . . . . . .WARRANTYCODE
DepVal:REQUIRED ValGroup:NotC
omment,ItemRequired,
RegularItem,WarrantyTracking
43 ExpirationDate. . . . . . . . 8 SNN Expiration Date . . . . . . . .DATE
ValGroup:NotComment,
ItemRequired,RegularItem,
WarrantyTracking
44 ExpirationOverridden. . . . . 1 SYN Expiration Overridden . . . . .YESNO
DfltVal:N Valid:Y,N
ValGroup:NotComment
45 CostOverridden. . . . . . . . 1 SYN Cost Overridden . . . . . . . .YESNO
DfltVal:N Valid:Y,N
ValGroup:NotComment
46 ItemAction. . . . . . . . . . 1 SYN Item Action . . . . . . . . . .
DfltVal:N Valid:N,S,P,R
ValGroup:NotComment Notes:
N=None, S=Stock, P=scraP,
R=Repair
47 CostCode. . . . . . . . . . . 9 SYN Cost Code . . . . . . . . . . .COSTCODE
FmtType:CHARNUM DepVal:REQUIR
ED ValGroup:PostJCCosts,
NotComment
48 CostType. . . . . . . . . . . 1 SYN Cost Type . . . . . . . . . . .COSTTYPE
DepVal:REQUIRED ValGroup:Post
JCCosts,NotComment
49 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . .COMMENT
DepVal:REQUIRED ValGroup:Item
Required
50 PromiseDate . . . . . . . . . 8 SNN Promise Date. . . . . . . . . .DATE
ValGroup:NotComment
51 QuantityOrdered . . . . . . . 16.6 NNN Quantity Ordered. . . . . . . .QUANTITY
Mask:##,###,###.000000-
ValGroup:NotComment,
ItemRequired,ItemTypes
52 QuantityShipped . . . . . . . 16.6 NNN Quantity Shipped. . . . . . . .QUANTITY
Mask:##,###,###.000000-
ValGroup:NotComment,
ItemRequired,ItemTypes
53 QuantityBackordered . . . . . 16.6 NNN Quantity Backordered. . . . . .QUANTITY
Mask:##,###,###.000000-
ValGroup:NotComment,
ItemRequired,ItemTypes
54 UnitPrice . . . . . . . . . . 16.6 NNN Unit Price. . . . . . . . . . .PRICE
Mask:##,###,###.000000-
ValGroup:NotComment,
ItemRequired,ItemTypes,
NotComponent
55 ExtensionAmt. . . . . . . . . 12.2 NNN Extension Amount. . . . . . . .
Mask:##,###,###.00-
ValGroup:NotComment,
ItemRequired
56 ExtendedCost. . . . . . . . . 12.2 NNN Extended Cost . . . . . . . . .COST
Mask:##,###,###.00-
57 ExtendedNegQtyAdj . . . . . . 12.2 NNN Extended Negative Quantity Adju
Mask:##,###,###.00-
58 UnitCost. . . . . . . . . . . 16.6 NNN Unit Cost . . . . . . . . . . .COST
Mask:##,###,###.000000-
ValGroup:NotComment,
ItemRequired,ItemTypes
Notes: {Calc @ Pre (Unless
Ds)}
59 UnitOfMeasureConvFactor . . . 12.4 NNN Unit Of Measure Conversion FactUMCONVFACTOR
Mask:#####0.0000 ValGroup:Not
Comment
60 CommissionAmt . . . . . . . . 13.2 NNN Commission Amount . . . . . . .AMOUNT
Mask:###,###,###.00
ValGroup:NotComment Notes:
(Calc @ Pre-Update)
61 QuantityPerBill . . . . . . . 16.6 NNN Quantity Per Bill . . . . . . .QUANTITY
Mask:##,###,###.000000-
ValGroup:NotComment
62 LineDiscountPercent . . . . . 9.3 NNN Line Discount Percent . . . . .
Mask:###0.000- ValGroup:NotCo
mment,LineDiscount,ItemRequir
ed,ItemTypes
63 LineWeight. . . . . . . . . . 12.2 NNN Line Weight . . . . . . . . . .MISCAMOUNT
Read Only:Y Mask:##,###,
###.00-