SAC_PO_HDR_VW (SQL View)	Index Back
Purchase Order Header Purchase Order Header

SAC_PO_HDR_VW

(SQL View)

Purchase Order Header

SELECT A.BUSINESS_UNIT , A.PO_ID , A.CHNG_ORD_BATCH , A.PO_TYPE , A.PO_STATUS , A.HOLD_STATUS , A.RECV_STATUS , A.DISP_ACTION , A.DISP_METHOD , A.CHANGE_STATUS , A.PO_DT , A.PO_REF , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , A.PRICE_SETID , A.PRICE_VENDOR , A.PRICE_LOC , A.PYMNT_TERMS_CD , A.BUYER_ID , A.ORIGIN , A.CHNG_ORD_SEQ , A.ADDRESS_SEQ_NUM , A.CNTCT_SEQ_NUM , A.SALES_CNTCT_SEQ_N , A.BILL_LOCATION , A.TAX_EXEMPT , A.TAX_EXEMPT_ID , A.CURRENCY_CD , A.RT_TYPE , A.MATCH_ACTION , A.MATCH_CNTRL_ID , A.MATCH_STATUS_PO , A.MATCH_PROCESS_FLG , A.PROCESS_INSTANCE , A.APPL_JRNL_ID_ENC , A.POST_DOC , A.DST_CNTRL_ID , A.OPRID_ENTERED_BY , A.ENTERED_DT , A.OPRID_APPROVED_BY , A.APPROVAL_DT , A.OPRID_MODIFIED_BY , A.LAST_DTTM_UPDATE , A.ACCOUNTING_DT , A.BUSINESS_UNIT_GL , A.IN_PROCESS_FLG , A.ACTIVITY_DATE , A.PO_POST_STATUS , A.NEXT_MOD_SEQ_NBR , A.ERS_ACTION , A.ACCRUE_USE_TAX , A.CURRENCY_CD_BASE , A.RATE_DATE , A.RATE_MULT , A.RATE_DIV , A.VAT_ENTITY , A.LC_ID , A.BUDGET_HDR_STS_NP , A.PREPAID_PO_FLG , A.PREPAID_AMT , A.PREPAID_AUTH_STAT , A.PREPAID_STATUS_PO , A.PAY_TRM_BSE_DT_OPT , A.TERMS_BASIS_DT , A.BACKORDER_STATUS , A.DOC_TOL_HDR_STATUS , A.MID_ROLL_STATUS , %subrec(PUR_USR_HDR_SBR, A) , A.BUDGET_CHECK , B.PHONE , B.FAX , D.NAME1 , C.ADDRESS1 , C.ADDRESS2 , C.CITY , C.STATE , C.POSTAL , C.COUNTRY ,C.EMAILID FROM PS_PO_HDR A , PS_BUYER_TBL B , PS_VENDOR_ADDR C , PS_VENDOR D WHERE A.VENDOR_SETID = D.SETID AND A.VENDOR_ID = D.VENDOR_ID AND A.VENDOR_SETID = C.SETID AND A.VENDOR_ID = C.VENDOR_ID AND A.ADDRESS_SEQ_NUM = C.ADDRESS_SEQ_NUM AND A.BUYER_ID = B.BUYER_ID AND C.EFFDT = ( SELECT MAX(EFFDT) FROM PS_VENDOR_ADDR WHERE C.SETID = SETID AND C.VENDOR_ID = VENDOR_ID AND EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
Default Value: NEXT

3 CHNG_ORD_BATCH Number(3,0) SMALLINT NOT NULL Change Order Number

4 PO_TYPE Character(4) VARCHAR2(4) NOT NULL PO Type
GEN=General
KAN=Kanban
Default Value: GEN

5 PO_STATUS Character(2) VARCHAR2(2) NOT NULL PO Status
A=Approved
C=Complete
D=Dispatched
DA=Denied
I=Initial
LD=Line Denied
O=Open
PA=Pending Approval/Approved
PX=Pending Cancel
X=Canceled
Default Value: I

6 HOLD_STATUS Character(1) VARCHAR2(1) NOT NULL Hold From Further Processing
Default Value: N

7 RECV_STATUS Character(1) VARCHAR2(1) NOT NULL Receipt Status
C=Closed Receipt
H=Hold Receipt
M=Moved to Destination
N=PO Not Received
O=Open
P=PO Partially Received
R=Fully Received
X=Canceled
Default Value: N

8 DISP_ACTION Character(1) VARCHAR2(1) NOT NULL Allow Dispatch When Appr
Default Value: Y

9 DISP_METHOD Character(3) VARCHAR2(3) NOT NULL Dispatch Method
EDX=Electronic Document Exchange
EML=Email Dispatch
FAX=Fax Transmission
PHN=Phone Dispatch
PRN=Print

10 CHANGE_STATUS Character(1) VARCHAR2(1) NOT NULL Change Order Status
C=Changed
U=Unchanged
Default Value: U

11 PO_DT Date(10) DATE NOT NULL Date
Default Value: %date

12 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.

13 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

14 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

15 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

16 PRICE_SETID Character(5) VARCHAR2(5) NOT NULL Price From Vendor SetID

17 PRICE_VENDOR Character(10) VARCHAR2(10) NOT NULL Price Vendor ID

18 PRICE_LOC Character(10) VARCHAR2(10) NOT NULL Price from Location

19 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.

20 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer

21 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin

22 CHNG_ORD_SEQ Number(3,0) SMALLINT NOT NULL Change Order Sequence Number

23 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
Default Value: VENDOR.ADDR_SEQ_NUM_ORDR

24 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number

25 SALES_CNTCT_SEQ_N Number(3,0) SMALLINT NOT NULL Salesperson

26 BILL_LOCATION Character(10) VARCHAR2(10) NOT NULL Billing Location
Default Value: BUS_UNIT_TBL_PM.BILL_LOCATION

27 TAX_EXEMPT Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag
Default Value: BUS_UNIT_TBL_PM.TAX_EXEMPT

28 TAX_EXEMPT_ID Character(30) VARCHAR2(30) NOT NULL Tax Exempt ID

29 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Default Value: BUS_UNIT_TBL_PM.CURRENCY_CD

30 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Default Value: BUS_UNIT_TBL_PM.RT_TYPE

31 MATCH_ACTION Character(1) VARCHAR2(1) NOT NULL Match Action
N=No Match
Y=Standard
Default Value: N

32 MATCH_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Match Rule

33 MATCH_STATUS_PO Character(1) VARCHAR2(1) NOT NULL Match Status
M=Matched
N=Not Required
P=Partially Matched
T=To Match
Default Value: N

34 MATCH_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL Match In Process
I=In Process
N=No
Default Value: N

35 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

36 APPL_JRNL_ID_ENC Character(10) VARCHAR2(10) NOT NULL Encumbrance

37 POST_DOC Character(1) VARCHAR2(1) NOT NULL Post Document
Default Value: Y

38 DST_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Accounting Template
Default Value: BUS_UNIT_OPT_PM.DST_CNTRL_ID

39 OPRID_ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes

40 ENTERED_DT Date(10) DATE Entered on

41 OPRID_APPROVED_BY Character(30) VARCHAR2(30) NOT NULL Approved By

42 APPROVAL_DT Date(10) DATE Date of Approval

43 OPRID_MODIFIED_BY Character(30) VARCHAR2(30) NOT NULL Last User to Modify Entered By 07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase.

44 LAST_DTTM_UPDATE DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

45 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

46 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
Default Value: BUS_UNIT_TBL_PM.BUSINESS_UNIT_GL

47 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag
Default Value: N

48 ACTIVITY_DATE Date(10) DATE Last Activity

49 PO_POST_STATUS Character(1) VARCHAR2(1) NOT NULL Post Status
D=Distributed
N=None
Default Value: N

50 NEXT_MOD_SEQ_NBR Number(3,0) SMALLINT NOT NULL Next Modification Number

51 ERS_ACTION Character(1) VARCHAR2(1) NOT NULL ERS Action
N=No
Y=Yes
Default Value: N

52 ACCRUE_USE_TAX Character(1) VARCHAR2(1) NOT NULL Accrue Use Tax
Default Value: BUS_UNIT_TBL_PM.ACCRUE_USE_TAX

53 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency

54 RATE_DATE Date(10) DATE Exchange Rate Date

55 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
Default Value: 1

56 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
Default Value: 1

57 VAT_ENTITY Character(20) VARCHAR2(20) NOT NULL Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.

58 LC_ID Character(12) VARCHAR2(12) NOT NULL Treasury Letter of Credit Number Assigned by the System

59 BUDGET_HDR_STS_NP Character(1) VARCHAR2(1) NOT NULL Budget Ch'k Hdr Sts NonProrate
E=Error in Budget Check
N=Not Budget Checked
P=Provisionally Valid
V=Valid Budget Check
Default Value: V

60 PREPAID_PO_FLG Character(1) VARCHAR2(1) NOT NULL Prepaid PO Flag
Default Value: N

61 PREPAID_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Prepaid Amount

62 PREPAID_AUTH_STAT Character(1) VARCHAR2(1) NOT NULL Prepaid Authorization Status
A=Authorized
N=Not Approved
P=Pending Authorization
Default Value: N

63 PREPAID_STATUS_PO Character(1) VARCHAR2(1) NOT NULL Prepaid PO Status
N=Not Processed
P=Processing
V=Vouchered
Default Value: N

64 PAY_TRM_BSE_DT_OPT Character(1) VARCHAR2(1) NOT NULL Payment Terms Basis Date Type
A=Acct Date
C=Doc Date
I=Inv Date
R=Recpt Date
S=Ship Date
U=User Date

65 TERMS_BASIS_DT Date(10) DATE Payment Terms Basis Date

66 BACKORDER_STATUS Character(1) VARCHAR2(1) NOT NULL Back Order Status
1=Not Backordered
2=Backordered
3=Backordered Received
Default Value: 1

67 DOC_TOL_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Document Heade Document Tolerance Status
E=Error
N=Not Checked
R=Reset
V=Valid
Default Value: V

68 MID_ROLL_STATUS Character(1) VARCHAR2(1) NOT NULL Mid Roll Status
Default Value: N

69 USER_HDR_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1

70 CUSTOM_C100_A1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1

71 CUSTOM_C100_A2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2

72 CUSTOM_C100_A3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3

73 CUSTOM_C100_A4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4

74 CUSTOM_DATE_A Date(10) DATE Custom Date

75 CUSTOM_C1_A Character(1) VARCHAR2(1) NOT NULL Custom Character 2

76 BUDGET_CHECK Character(1) VARCHAR2(1) NOT NULL Budget Checked
N=No
Y=Yes
Default Value: N

77 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone

78 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number

79 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1

80 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1

81 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2

82 CITY Character(30) VARCHAR2(30) NOT NULL City

83 STATE Character(6) VARCHAR2(6) NOT NULL State

84 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal

85 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

86 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
2	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order Default Value: NEXT
3	CHNG_ORD_BATCH	Number(3,0)	SMALLINT NOT NULL	Change Order Number
4	PO_TYPE	Character(4)	VARCHAR2(4) NOT NULL	PO Type GEN=General KAN=Kanban Default Value: GEN
5	PO_STATUS	Character(2)	VARCHAR2(2) NOT NULL	PO Status A=Approved C=Complete D=Dispatched DA=Denied I=Initial LD=Line Denied O=Open PA=Pending Approval/Approved PX=Pending Cancel X=Canceled Default Value: I
6	HOLD_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Hold From Further Processing Default Value: N
7	RECV_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Receipt Status C=Closed Receipt H=Hold Receipt M=Moved to Destination N=PO Not Received O=Open P=PO Partially Received R=Fully Received X=Canceled Default Value: N
8	DISP_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Allow Dispatch When Appr Default Value: Y
9	DISP_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Dispatch Method EDX=Electronic Document Exchange EML=Email Dispatch FAX=Fax Transmission PHN=Phone Dispatch PRN=Print
10	CHANGE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Change Order Status C=Changed U=Unchanged Default Value: U
11	PO_DT	Date(10)	DATE NOT NULL	Date Default Value: %date
12	PO_REF	Character(30)	VARCHAR2(30) NOT NULL	Specifies the purchase order number associated with a receivables item.
13	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
14	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
15	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
16	PRICE_SETID	Character(5)	VARCHAR2(5) NOT NULL	Price From Vendor SetID
17	PRICE_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Price Vendor ID
18	PRICE_LOC	Character(10)	VARCHAR2(10) NOT NULL	Price from Location
19	PYMNT_TERMS_CD	Character(5)	VARCHAR2(5) NOT NULL	Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
20	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer
21	ORIGIN	Character(3)	VARCHAR2(3) NOT NULL	Origin
22	CHNG_ORD_SEQ	Number(3,0)	SMALLINT NOT NULL	Change Order Sequence Number
23	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number Default Value: VENDOR.ADDR_SEQ_NUM_ORDR
24	CNTCT_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Contact Sequence Number
25	SALES_CNTCT_SEQ_N	Number(3,0)	SMALLINT NOT NULL	Salesperson
26	BILL_LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Billing Location Default Value: BUS_UNIT_TBL_PM.BILL_LOCATION
27	TAX_EXEMPT	Character(1)	VARCHAR2(1) NOT NULL	Tax Exempt Flag Default Value: BUS_UNIT_TBL_PM.TAX_EXEMPT
28	TAX_EXEMPT_ID	Character(30)	VARCHAR2(30) NOT NULL	Tax Exempt ID
29	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: BUS_UNIT_TBL_PM.CURRENCY_CD
30	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. Default Value: BUS_UNIT_TBL_PM.RT_TYPE
31	MATCH_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Match Action N=No Match Y=Standard Default Value: N
32	MATCH_CNTRL_ID	Character(10)	VARCHAR2(10) NOT NULL	Match Rule
33	MATCH_STATUS_PO	Character(1)	VARCHAR2(1) NOT NULL	Match Status M=Matched N=Not Required P=Partially Matched T=To Match Default Value: N
34	MATCH_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Match In Process I=In Process N=No Default Value: N
35	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
36	APPL_JRNL_ID_ENC	Character(10)	VARCHAR2(10) NOT NULL	Encumbrance
37	POST_DOC	Character(1)	VARCHAR2(1) NOT NULL	Post Document Default Value: Y
38	DST_CNTRL_ID	Character(10)	VARCHAR2(10) NOT NULL	Accounting Template Default Value: BUS_UNIT_OPT_PM.DST_CNTRL_ID
39	OPRID_ENTERED_BY	Character(30)	VARCHAR2(30) NOT NULL	Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes
40	ENTERED_DT	Date(10)	DATE	Entered on
41	OPRID_APPROVED_BY	Character(30)	VARCHAR2(30) NOT NULL	Approved By
42	APPROVAL_DT	Date(10)	DATE	Date of Approval
43	OPRID_MODIFIED_BY	Character(30)	VARCHAR2(30) NOT NULL	Last User to Modify Entered By 07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase.
44	LAST_DTTM_UPDATE	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
45	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
46	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit Default Value: BUS_UNIT_TBL_PM.BUSINESS_UNIT_GL
47	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In process flag Default Value: N
48	ACTIVITY_DATE	Date(10)	DATE	Last Activity
49	PO_POST_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Post Status D=Distributed N=None Default Value: N
50	NEXT_MOD_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Next Modification Number
51	ERS_ACTION	Character(1)	VARCHAR2(1) NOT NULL	ERS Action N=No Y=Yes Default Value: N
52	ACCRUE_USE_TAX	Character(1)	VARCHAR2(1) NOT NULL	Accrue Use Tax Default Value: BUS_UNIT_TBL_PM.ACCRUE_USE_TAX
53	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
54	RATE_DATE	Date(10)	DATE	Exchange Rate Date
55	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier Default Value: 1
56	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor Default Value: 1
57	VAT_ENTITY	Character(20)	VARCHAR2(20) NOT NULL	Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.
58	LC_ID	Character(12)	VARCHAR2(12) NOT NULL	Treasury Letter of Credit Number Assigned by the System
59	BUDGET_HDR_STS_NP	Character(1)	VARCHAR2(1) NOT NULL	Budget Ch'k Hdr Sts NonProrate E=Error in Budget Check N=Not Budget Checked P=Provisionally Valid V=Valid Budget Check Default Value: V
60	PREPAID_PO_FLG	Character(1)	VARCHAR2(1) NOT NULL	Prepaid PO Flag Default Value: N
61	PREPAID_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Prepaid Amount
62	PREPAID_AUTH_STAT	Character(1)	VARCHAR2(1) NOT NULL	Prepaid Authorization Status A=Authorized N=Not Approved P=Pending Authorization Default Value: N
63	PREPAID_STATUS_PO	Character(1)	VARCHAR2(1) NOT NULL	Prepaid PO Status N=Not Processed P=Processing V=Vouchered Default Value: N
64	PAY_TRM_BSE_DT_OPT	Character(1)	VARCHAR2(1) NOT NULL	Payment Terms Basis Date Type A=Acct Date C=Doc Date I=Inv Date R=Recpt Date S=Ship Date U=User Date
65	TERMS_BASIS_DT	Date(10)	DATE	Payment Terms Basis Date
66	BACKORDER_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Back Order Status 1=Not Backordered 2=Backordered 3=Backordered Received Default Value: 1
67	DOC_TOL_HDR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Document Heade Document Tolerance Status E=Error N=Not Checked R=Reset V=Valid Default Value: V
68	MID_ROLL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Mid Roll Status Default Value: N
69	USER_HDR_CHAR1	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 1
70	CUSTOM_C100_A1	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 1
71	CUSTOM_C100_A2	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 2
72	CUSTOM_C100_A3	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 3
73	CUSTOM_C100_A4	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 4
74	CUSTOM_DATE_A	Date(10)	DATE	Custom Date
75	CUSTOM_C1_A	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 2
76	BUDGET_CHECK	Character(1)	VARCHAR2(1) NOT NULL	Budget Checked N=No Y=Yes Default Value: N
77	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
78	FAX	Character(24)	VARCHAR2(24) NOT NULL	Fax Number
79	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
80	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
81	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
82	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
83	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
84	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
85	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
86	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address