PO_ReceiptHeader PO Receipt Header Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: PO_Receipt_bus,BC_CommonImport
SQL Def: Y SysDB: N "MAS_"+%C$+"/PO"+%C$+"/PO_ReceiptHeader.M4T"
KPRIMARY: ReceiptType+ReceiptNo
KPONUMBER: PurchaseOrderNo+ReceiptType+ReceiptNo
KBATCH: BatchNo+ReceiptType+ReceiptNo
KINVOICE: InvoiceNo+ReceiptType+ReceiptNo
Fld Column Name M/L TUR Description/Notes Class
1 ReceiptType . . . . . . . . . 1 SYY Receipt Type. . . . . . . . . .
Valid:G,I Notes: {PO5$(1,
1)}(Goods,Invoice)
2 ReceiptNo . . . . . . . . . . 6 SYY Receipt Number. . . . . . . . .RECEIPTNO
FmtType:CHARNUM Next:ReceiptT
ype$+SEP+ReceiptNo$ Notes:
{PO5$(2,6)}
3 ReceiptDate . . . . . . . . . 8 SNY Receipt Date. . . . . . . . . .DATE
Notes: {PO5$(8,6)}
4 PurchaseOrderNo . . . . . . . 7 SYN Purchase Order Number . . . . .PURCHASEORDERNO
FmtType:CHARNUM DepVal:REQUIR
ED Notes: {PO5$(15,7)}
5 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . .APDIVISION
Mask:00 FmtType:ZEROFILL
DepVal:REQUIRED ValGroup:PO_I
nvoiceNoRequired Notes:
{PO5$(22,2)}
6 VendorNo. . . . . . . . . . . 7 SYN Vendor Number . . . . . . . . .VENDORNO
FmtType:MASTERNUM DepVal:REQU
IRED ValGroup:PO_InvoiceNoReq
uired ChngTag:Replace1/APDivi
sionNo$ Notes: {PO5$(24,7)}
7 PurchaseName. . . . . . . . . 30 SNN Purchase Name . . . . . . . . .NAME
ValGroup:VendorRequired
Notes: {PO5$(31,30)}
8 PurchaseAddress1. . . . . . . 30 SNN Purchase Address 1. . . . . . .ADDRESSLINE
ValGroup:VendorRequired
Notes: {PO5$(61,30)}
9 PurchaseAddress2. . . . . . . 30 SNN Purchase Address 2. . . . . . .ADDRESSLINE
ValGroup:VendorRequired
Notes: {PO5$(91,30)}
10 PurchaseAddress3. . . . . . . 30 SNN Purchase Address 3. . . . . . .ADDRESSLINE
ValGroup:VendorRequired
Notes: {PO5$(501,30)}
11 PurchaseCity. . . . . . . . . 20 SNN Purchase City . . . . . . . . .CITY
ValGroup:VendorRequired
Notes: {PO5$(121,20)}
12 PurchaseState . . . . . . . . 2 SYN Purchase State. . . . . . . . .STATE
ValGroup:VendorRequired
Notes: {PO5$(141,2)}
13 PurchaseZipCode . . . . . . . 10 SYN Purchase Zip Code . . . . . . .ZIPCODE
ValGroup:VendorRequired
Notes: {PO5$(143,10)}
14 PurchaseCountryCode . . . . . 3 SYN Purchase Country Code . . . . .COUNTRY
ValGroup:VendorRequired
Notes: {PO5$(531,3)}
15 PurchaseAddressCode . . . . . 4 SYN Purchase Address Code . . . . .PURCHASEADDRCODE
DepVal:REQUIRED ValGroup:Vend
orRequired Notes: {PO5$(286,
4)}
16 ShipToCode. . . . . . . . . . 4 SYN Ship To Code. . . . . . . . . .SHIPTO
Notes: {PO5$(153,4)}This is
a dual purpose field and
could hold either the PO
Ship To Code or SO Ship To
Code.
17 ShipToName. . . . . . . . . . 30 SNN Ship To Name. . . . . . . . . .NAME
Notes: {PO5$(157,30)}
18 ShipToAddress1. . . . . . . . 30 SNN Ship To Address 1 . . . . . . .ADDRESSLINE
Notes: {PO5$(187,30)}
19 ShipToAddress2. . . . . . . . 30 SNN Ship To Address 2 . . . . . . .ADDRESSLINE
Notes: {PO5$(217,30)}
20 ShipToAddress3. . . . . . . . 30 SNN Ship To Address 3 . . . . . . .ADDRESSLINE
Notes: {PO5$(551,30)}
21 ShipToCity. . . . . . . . . . 20 SNN Ship To City. . . . . . . . . .CITY
Notes: {PO5$(247,20)}
22 ShipToState . . . . . . . . . 2 SYN Ship To State . . . . . . . . .STATE
Notes: {PO5$(267,2)}
23 ShipToZipCode . . . . . . . . 10 SYN Ship To Zip Code. . . . . . . .ZIPCODE
Notes: {PO5$(269,10)}
24 ShipToCountryCode . . . . . . 3 SYN Ship To Country Code. . . . . .COUNTRY
Notes: {PO5$(581,3)}
25 EmailAddress. . . . . . . . . 250 SNN Email Address . . . . . . . . .EMAILADDRESS
26 OrderStatus . . . . . . . . . 1 SYN Order Status. . . . . . . . . .
Read Only:Y Valid:N,O,B,C,X
Notes: {PO5$(279,1)}(N=New,
O=Open, B=Backordered,
C=Change, X=complete)
27 RequiredDate. . . . . . . . . 8 SNN Required Date . . . . . . . . .DATE
Notes: {PO5$(280,6)}
28 UseTax. . . . . . . . . . . . 1 SYN Use Tax . . . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N
ValGroup:APSalesTax Notes:
{PO5$(290,1)}
29 ShipVia . . . . . . . . . . . 15 SYN Ship Via. . . . . . . . . . . .SHIPCODE
Notes: {PO5$(301,15)}
30 FOB . . . . . . . . . . . . . 15 SNN F.O.B.. . . . . . . . . . . . .
Notes: {PO5$(316,15)}
31 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE
FmtType:CHARNUM DepVal:REQUIR
ED ValGroup:MultiWarehouse
Notes: {PO5$(331,3)}
32 ConfirmTo . . . . . . . . . . 30 SNN Confirm To. . . . . . . . . . .
Notes: {PO5$(334,30)}
33 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . .COMMENT30
Notes: {PO5$(364,30)}
34 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .ARDIVISION
Mask:00 ValGroup:DropShip
Notes: {PO5$(394,2)}(If Drop
Ship)
35 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . .CUSTOMERNO
ValGroup:DropShip Notes:
{PO5$(396,7)} (If Drop Ship)
36 TermsCode . . . . . . . . . . 2 SNN Terms Code. . . . . . . . . . .APTERMS
Mask:00 FmtType:ZEROFILL
Notes: {PO5$(403,2)}
37 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE
DepVal:REQUIRED Notes:
{PO5$(405,6)}
38 InvoiceNo . . . . . . . . . . 10 SNN AP Invoice Number . . . . . . .APINVOICE
DepVal:REQUIRED ValGroup:PORe
quired Notes: {PO5$(411,10)}
39 Form1099. . . . . . . . . . . 1 SYN 1099 Form . . . . . . . . . . .FORM1099
DfltVal:N Valid:N,M,I,D
DepVal:REQUIRED ValGroup:Ten9
9 Notes: {PO5$(421,1)}
N=None, M=Miscellaneous,
I=Interest, D=Dividend
40 Box1099 . . . . . . . . . . . 3 SNN 1099 Box. . . . . . . . . . . .BOX1099
ValGroup:Ten99 Notes:
{PO5$(422,2)}
41 JobNo . . . . . . . . . . . . 7 SYN Job Number. . . . . . . . . . .JOBNO
FmtType:CHARNUM DepVal:REQUIR
ED ValGroup:JCIntegrated
Notes: {PO5$(424,7)}
42 LastReceiptDate . . . . . . . 8 SNN Last Receipt Date . . . . . . .DATE
Read Only:Y Notes: {PO5$(431,
6)}
43 LastReceiptNo . . . . . . . . 7 SNN Last Receipt Number . . . . . .RECEIPTNO
Read Only:Y Notes: {PO5$(437,
7)}
44 CODCheckNo. . . . . . . . . . 10 SYN COD Check Number. . . . . . . .APCHECKNO
DepVal:REQUIRED Notes:
{PO5$(444,6)}
45 BankCode. . . . . . . . . . . 1 SYN Bank Code . . . . . . . . . . .BANKCODE
Notes: {PO5$(450,1)}
46 SecondReceiptForThisPO. . . . 1 SYN Second Receipt For This Po. . .YESNO
DfltVal:N Valid:Y,N Notes:
{PO5$(451,1)}
47 PurchaseOrderType . . . . . . 1 SYN Purchase Order Type . . . . . .
Read Only:Y Valid:S,D Notes:
{PO5$(459,1)} (S=Standard,
D=Drop Ship)
48 PurchaseOrderDate . . . . . . 8 SNN Purchase Order Date . . . . . .DATE
Read Only:Y Notes: {PO5$(460,
6)}
49 PrepaidCheckNo. . . . . . . . 10 SYN Prepaid AP Check Number . . . .APCHECKNO
Notes: {PO5$(466,6)}
50 InvoiceDueDate. . . . . . . . 8 SNN Invoice Due Date. . . . . . . .DATE
Notes: {PO5$(472,6)}
51 DiscountDueDate . . . . . . . 8 SNN Discount Due Date . . . . . . .DATE
Notes: {PO5$(478,6)}
52 HoldPayment . . . . . . . . . 1 SYN Hold Payment. . . . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{PO5$(484,1)}
53 CODNo . . . . . . . . . . . . 10 SNN C.O.D. Number . . . . . . . . .
DepVal:REQUIRED Notes:
{PO5$(485,10)}
54 LotSerialLinesExist . . . . . 1 SYN Lot/Serial Lines Exist. . . . .YESNO
Read Only:Y DfltVal:N
Valid:Y,N Notes: {PO5$(495,
1)}
55 BatchNo . . . . . . . . . . . 5 SYN Batch Number. . . . . . . . . .BATCHNO
Notes: {PO5$(496,5)}
56 TaxSchedule . . . . . . . . . 9 SYN Tax Schedule. . . . . . . . . .TAXSCHEDULE
DepVal:REQUIRED ValGroup:APSa
lesTax Notes: {PO5$(584,9)}
57 InvalidTaxCalc. . . . . . . . 1 SYN Invalid Tax Calculation . . . .YESNO
DfltVal:N Valid:Y,N
ValGroup:APSalesTax Notes:
{PO5$(593,1)}
58 UpdateSeqNo . . . . . . . . . 3 SNN Update Sequence Number. . . . .
Mask:000 Notes: {PO5$(604,
3)}(Calced At Update Time)
59 PrepaidAmt. . . . . . . . . . 13.2 NNN Prepaid Amount. . . . . . . . .AMOUNT
Mask:###,###,###.00-
DepVal:REQUIRED Notes:
{PO5[1]}
60 TaxableAmt. . . . . . . . . . 13.2 NNN Taxable Amount. . . . . . . . .AMOUNT
Read Only:Y Mask:###,###,
###.00- Notes: {PO5[2]}
61 NontaxableAmt . . . . . . . . 13.2 NNN Non-Taxable Amount. . . . . . .AMOUNT
Read Only:Y Mask:###,###,
###.00- Notes: {PO5[3]}
62 SalesTaxAmt . . . . . . . . . 13.2 NNN Sales Tax Amount. . . . . . . .AMOUNT
Read Only:Y Mask:###,###,
###.00- Notes: {PO5[5]}
63 FreightAmt. . . . . . . . . . 12.2 NNN Freight Amount. . . . . . . . .MISCAMOUNT
Mask:##,###,###.00- Notes:
{PO5[6]}
64 PrepaidFreightAmt . . . . . . 12.2 NNN Prepaid Freight Amount. . . . .MISCAMOUNT
Mask:##,###,###.00- Notes:
{PO5[11]}
65 DiscountAmt . . . . . . . . . 12.2 NNN Discount Amount . . . . . . . .MISCAMOUNT
Mask:##,###,###.00- Notes:
{PO5[7]}
66 TotalMiscChargeAmt. . . . . . 13.2 NNN Total Miscellaneous Charge AmouAMOUNT
Read Only:Y Mask:###,###,
###.00- Notes: {PO5[8]}
67 TotalCostForFreightAllocation 13.2 NNN Total Cost For Freight AllocatiAMOUNT
Read Only:Y Mask:###,###,
###.00- Notes: {PO5[10]}
68 CODAmt. . . . . . . . . . . . 13.2 NNN COD Amount. . . . . . . . . . .AMOUNT
Mask:###,###,###.00-
DepVal:REQUIRED Notes:
{PO5[12]}
69 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
70 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . .
Read Only:Y
71 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER
Read Only:Y Mask:0000000000
72 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
73 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y
74 UserUpdatedKey. . . . . . . . 10 SNN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000