PO_SRC_TMP_BU

(SQL Table)
Index Back

AutoSource BU Work table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
4 ACCOUNTING_DT_IND Character(1) VARCHAR2(1) NOT NULL Accounting Date Indicator
C=Use Current Date
D=Business Unit Default
P=Use Payment Date
S=Use Specific Date
5 ACCRUE_USE_TAX Character(1) VARCHAR2(1) NOT NULL Accrue Use Tax
6 ALLOW_MC_PO Character(1) VARCHAR2(1) NOT NULL Allow Multicurrency PO
N=No
Y=Yes
7 APPL_JRNL_ID_ENCM Character(10) VARCHAR2(10) NOT NULL Encumbrance
8 BILL_LOCATION Character(10) VARCHAR2(10) NOT NULL Billing Location
9 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit
10 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
11 CNTRCT_SETID Character(5) VARCHAR2(5) NOT NULL SetID
12 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
13 DECIMAL_POS_BSE Number(2,0) SMALLINT NOT NULL Base Cur Decimal Positions
14 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.
15 DST_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Accounting Template
16 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
17 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
18 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
19 LOC_SETID Character(5) VARCHAR2(5) NOT NULL Location Setid
20 MATCH_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Match Rule
21 MATCH_OPT Character(1) VARCHAR2(1) NOT NULL Requires Matching
22 MATCH_SETID Character(5) VARCHAR2(5) NOT NULL Setid ID for Match Rules
23 PO_AMT_APPR_NEEDED Character(1) VARCHAR2(1) NOT NULL PO Amount Approval Needed
24 PO_CF_APPR_NEEDED Character(1) VARCHAR2(1) NOT NULL PO ChartField Approval Needed
25 PO_WF_APPR_NEEDED Character(1) VARCHAR2(1) NOT NULL Approval Workflow Needed
26 PO_COUNT Number(10,0) DECIMAL(10) NOT NULL PO Count by Business Unit
27 PO_ID_LAST_USED Number(10,0) DECIMAL(10) NOT NULL Last PO Number
28 PO_ITM_VNDR_OPT Character(1) VARCHAR2(1) NOT NULL PO Item Vendor Security Option
1=No Edit Required
2=Edit Required When Use Item ID
3=Edit Required Must Use Item ID
29 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.
30 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
31 TAX_EXEMPT Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag
32 TAX_EXEMPT_ID Character(30) VARCHAR2(30) NOT NULL Tax Exempt ID
33 TAX_SETID Character(5) VARCHAR2(5) NOT NULL Tax SetID
34 ITEM_BU_ATTR Character(1) VARCHAR2(1) NOT NULL Allow Business Item Attributes
35 VAT_TXN_TYPE_BU Character(4) VARCHAR2(4) NOT NULL VAT Transaction Type
36 VAT_USE_ID_BU Character(6) VARCHAR2(6) NOT NULL VAT Use Type
37 FRGHT_PRORATE_FLG Character(1) VARCHAR2(1) NOT NULL Prorate Freight Charges
38 MISC_PRORATE_FLG Character(1) VARCHAR2(1) NOT NULL Prorate Miscellaneous Charge
39 SALETX_PRORATE_FLG Character(1) VARCHAR2(1) NOT NULL Prorate Sales Tax
40 USETAX_PRORATE_FLG Character(1) VARCHAR2(1) NOT NULL Prorate Use Tax
41 VAT_NRCVR_PRO_FLG Character(1) VARCHAR2(1) NOT NULL Prorate Non-Recoverable VAT
42 VAT_PRORATE_FLG Character(1) VARCHAR2(1) NOT NULL Prorate VAT
43 FRT_CHRG_METHOD Character(2) VARCHAR2(2) NOT NULL Freight Charge Method
01=Order Value
02=Weight
03=Volume
04=Order Quantity
44 TRFT_RULE_CD Character(10) VARCHAR2(10) NOT NULL Arbitration Rule Code.
45 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
46 FRT_CHRG_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Freight Charge Override
47 VAT_APORT_CNTRL Character(1) VARCHAR2(1) NOT NULL VAT Apportionment Control
D=Distribution GL Business Unit
G=Transaction GL Business Unit
T=Transaction Business Unit
48 ENTRY_EVENT Character(10) VARCHAR2(10) NOT NULL Entry Event