PO_ReceiptHistoryDetail PO Receipt History Detail Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: PO_ReceiptRegister_upd,PO_ReceiptHistoryDetail_bus,PO_ReturnRegister_upd
SQL Def: Y SysDB: N "MAS_"+%C$+"/PO"+%C$+"/PO_ReceiptHistoryDetail.M4T"
KPRIMARY: PurchaseOrderNo+ReceiptType+ReceiptNo+HeaderSeqNo+ItemType+ItemCode+LineKey
KDISPLAY: PurchaseOrderNo+ReceiptType+ReceiptNo+HeaderSeqNo+LineSeqNo+LineKey+ItemType+ItemCode
KEXTENDEDDESC: ExtendedDescriptionKey+PurchaseOrderNo+ReceiptType+ReceiptNo+HeaderSeqNo+ItemType+ItemCo
de+LineKey(**) **=Case Sensitive
Fld Column Name M/L TUR Description/Notes Class
1 PurchaseOrderNo . . . . . . . 7 SYN Purchase Order Number . . . . .PURCHASEORDERNO
Mask:0000000 Notes: {POM$(1,
7)}
2 ReceiptType . . . . . . . . . 1 SYY Receipt Type. . . . . . . . . .
Valid:G,I Notes: {POM$(8,1)}
3 ReceiptNo . . . . . . . . . . 6 SYY Receipt Number. . . . . . . . .RECEIPTNO
Mask:0000000 Notes: {POM$(9,
6)}
4 HeaderSeqNo . . . . . . . . . 6 SNN Header Sequence Number. . . . .
5 ItemCode. . . . . . . . . . . 30 SYN Item Code . . . . . . . . . . .ITEMCODE
ChngTag:Replace0 Notes:
{POM$(16,15)}
6 LineKey . . . . . . . . . . . 6 SNN Line Key. . . . . . . . . . . .
Mask:000000 FmtType:ZEROFILL
Notes: {POM$(36,5)}
7 ItemType. . . . . . . . . . . 1 SYN Item Type . . . . . . . . . . .
Valid:1,2,5 Notes: {POM$(15,
1)}1=Regular Item,
2=Special Item, 3=Charge
Item, 4=Comment Item,
5=Miscellaneous Item
8 LineSeqNo . . . . . . . . . . 14 SNN Line Sequence Number. . . . . .
FmtType:ZEROFILL
9 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . .DESCRIPTION
Notes: {POM$(41,30)}
10 ExtendedDescriptionKey. . . . 10 SNN Extended Description Key. . . .EXTDESCKEY
Read Only:Y
11 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE
FmtType:CHARNUM Notes:
{POM$(71,3)}
12 UnitOfMeasure . . . . . . . . 4 SYN Unit Of Measure . . . . . . . .UNITOFMEASURE
Notes: {POM$(74,4)}
13 AllocateLandedCost. . . . . . 1 SYN Allocate Landed Cost. . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{POM$(78,1)}
14 UseTax. . . . . . . . . . . . 1 SYN Use Tax . . . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{POM$(79,1)}
15 JobNo . . . . . . . . . . . . 7 SYN Job Number. . . . . . . . . . .JOBNO
FmtType:CHARNUM Notes:
{POM$(80,7)}
16 CostCode. . . . . . . . . . . 9 SYN Cost Code . . . . . . . . . . .COSTCODE
Notes: {POM$(87,9)}
17 CostType. . . . . . . . . . . 1 SYN Cost Type . . . . . . . . . . .COSTTYPE
Notes: {POM$(96,1)}
18 WorkOrderNo . . . . . . . . . 7 SYN Work Order Number . . . . . . .WORKORDERNO
FmtType:CHARNUM ValGroup:WOIn
tegrated Notes: {POM$(80,7)}
19 StepNo. . . . . . . . . . . . 4 SNN Step Number . . . . . . . . . .
Mask:0000 ValGroup:WOIntegrat
ed Notes: {POM$(87,4)}
20 SubStepPrefix . . . . . . . . 1 SYN Sub Step Prefix . . . . . . . .
ValGroup:WOIntegrated Notes:
{POM$(91,1)}
21 SubStepSuffix . . . . . . . . 1 SYN Sub Step Suffix . . . . . . . .
ValGroup:WOIntegrated Notes:
{POM$(92,4)}
22 WorkOrderType . . . . . . . . 1 SNN Work Order Type . . . . . . . .
Mask:0 ValGroup:WOIntegrated
Notes: {POM$(96,1)}
23 Valuation . . . . . . . . . . 1 SYN Valuation . . . . . . . . . . .
Valid:1,2,3,4,5,6 Notes:
1=Standard, 2=Average,
3=Fifo, 4=Lifo, 5=Lot,
6=Serial {POM$(97,1)}
24 ExpenseAcctKey. . . . . . . . 9 SNN Expense Account Key . . . . . .ACCOUNT
Notes: {POM$(98,9)}
25 RequiredDate. . . . . . . . . 8 SNN Required Date . . . . . . . . .DATE
Notes: {POM$(107,6)}
26 TaxClass. . . . . . . . . . . 2 SYN Tax Class . . . . . . . . . . .TAXCLASS
Notes: {POM$(113,2)}
27 VendorPriceCode . . . . . . . 4 SYN Vendor Price Code . . . . . . .
Notes: {POM$(133,4)}
28 OrderWarehouseCode. . . . . . 3 SNN Order Warehouse Code. . . . . .WAREHOUSE
FmtType:CHARNUM Notes:
{POM$(137,3)}
29 ProductLine . . . . . . . . . 4 SYN Product Line. . . . . . . . . .PRODUCTLINE
Notes: {POM$(140,4)}
30 VendorAliasItemNo . . . . . . 30 SYN Vendor Alias Item Number. . . .
Notes: {POM$(154,30)}
31 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . .
32 WeightReference . . . . . . . 10 SNN Weight Reference. . . . . . . .
33 Weight. . . . . . . . . . . . 16.6 NNN Weight. . . . . . . . . . . . .MISCAMOUNT
Mask:##,###,###.00- Notes:
{POM$(144,10)}
34 QuantityReceived. . . . . . . 16.6 NNN Quantity Received . . . . . . .QUANTITY
Mask:##,###,###.000000-
Notes: {POM[0]}
35 ExtensionAmt. . . . . . . . . 12.2 NNN Extension Amount. . . . . . . .MISCAMOUNT
Mask:##,###,###.00- Notes:
{POM[1]}
36 UnitCost. . . . . . . . . . . 16.6 NNN Unit Cost . . . . . . . . . . .COST
Mask:##,###,###.000000-
Notes: {POM[2]}
37 OriginalUnitCost. . . . . . . 16.6 NNN Original Unit Cost. . . . . . .COST
Mask:##,###,###.000000-
38 OriginalQuantityOrdered . . . 16.6 NNN Original Quantity Ordered . . .QUANTITY
Mask:##,###,###.000000-
Notes: {POM[3]}
39 PreviousQuantityReceived. . . 16.6 NNN Previous Quantity Received. . .QUANTITY
Mask:##,###,###.000000-
Notes: {POM[5]}
40 PreviousQuantityInvoiced. . . 16.6 NNN Previous Quantity Invoiced. . .QUANTITY
Mask:##,###,###.000000-
Notes: {POM[6]}
41 UnitOfMeasureConvFactor . . . 12.4 NNN Unit Of Measure Conversion FactUMCONVFACTOR
Mask:#####0.0000 Notes:
{POM[4]}