PO_LN_DIST_EXT

(SQL Table)
Index Back

PO XMLP distrib

Date Initials Reference # Description 10/30/2008 SK F-AHAYT-D6Z26 9.1 PO XMLP Print

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: PO_HDR.BUSINESS_UNIT

2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
4 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
5 DST_ACCT_TYPE Character(4) VARCHAR2(4) NOT NULL 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment

Default Value: DST

6 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line

Default Value: 1

7 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
9 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
10 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
11 MERCH_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Merchandise Amount
12 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOCATION_TBL

13 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

Prompt Table: %EDIT_ACCOUNT

14 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account

Prompt Table: %EDIT_ALTACCT

15 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPTID_BUGL_VW

16 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: OPERUNT_BUGL_VW

17 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

Prompt Table: PRODUCT_BUGL_VW

18 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

Prompt Table: FUND_BUGL_VW

19 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

Prompt Table: CLASSCF_BUGL_VW

20 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

Prompt Table: PROGRAM_BUGL_VW

21 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

Prompt Table: BUD_REF_BUGL_VW

22 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

Prompt Table: AFFILIATE_VW

23 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

Prompt Table: %EDIT_INTRA01

24 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

Prompt Table: %EDIT_INTRA02

25 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

Prompt Table: CF1_BUGL_VW

26 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

Prompt Table: CF2_BUGL_VW

27 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

Prompt Table: CF3_BUGL_VW

28 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

Prompt Table: %EDIT_BU_PC

29 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: %EDIT_PROJECT

30 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

Prompt Table: %EDIT_ACTIVITY

31 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type

Prompt Table: PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC

32 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category

Prompt Table: %EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC

33 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory

Prompt Table: %EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC

34 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type

Prompt Table: %EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC

35 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code

Prompt Table: STAT_BUGL_VW

36 STATISTIC_AMOUNT Signed Number(17,2) DECIMAL(15,2) NOT NULL Specifies the amount associated with a statistical account on a journal line or a distribution line. It represents a quantity rather than a monetary amount and is qualified by the Unit of Measure associated with the STATISTICS_CODE or statistics ACCOUNT.
37 CHARTFIELD_STATUS Character(1) VARCHAR2(1) NOT NULL Chartfield Status
R=Recycled
V=Valid

Default Value: V

38 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

Default Value: BUS_UNIT_TBL_PM.BUSINESS_UNIT_GL

Prompt Table: SP_BUPRCR_NONVW

39 DISTRIB_LN_STATUS Character(1) VARCHAR2(1) NOT NULL Distribution Line Status
C=Closed
M=Mass Liquidated
O=Open
P=Unavailable for Sourcing
X=Canceled

Default Value: O

40 DIST_PROCESSED_FLG Character(1) VARCHAR2(1) NOT NULL Distribution Processed

Y/N Table Edit

Default Value: N

41 SYSTEM_SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.

Default Value: PPO

42 BUSINESS_UNIT_REQ Character(5) VARCHAR2(5) NOT NULL Requesting Business Unit
43 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
44 PROCESS_MAN_CLOSE Character(1) VARCHAR2(1) NOT NULL Process Manual Close
N=No
P=Processed
Y=Yes

Default Value: N

45 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
46 REQ_LINE_NBR Number(5,0) INTEGER NOT NULL Requisition Line Number
47 REQ_SCHED_NBR Number(3,0) SMALLINT NOT NULL Requisition Schedule Number
48 REQ_DISTRIB_NBR Number(5,0) INTEGER NOT NULL Requisition Distrib Number
49 PO_POST_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Post Amount
50 PO_POST_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Post Base Amount
51 PC_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL PC Distribution Status
B=Budget Check
D=Distributed
G=Generated
H=Hold
I=Ignore
M=Modified
N=Not Distributed
S=Staged

Default Value: N

52 PC_DISTRIB_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL PC Distribution Amount
53 PC_DISTRIB_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL PC Distribution Base Amount
54 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID

Prompt Table: %EDIT_PROFILE

55 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
56 CAP_NUM Character(15) VARCHAR2(15) NOT NULL Capital Acquisition Plan #

Prompt Table: CAP_VW

57 CAP_SEQUENCE Number(3,0) SMALLINT NOT NULL CAP Sequence

Prompt Table: CAP_DET_VW1

58 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSONAL_DATA

59 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

Prompt Table: %EDIT_BU_AM

60 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

Prompt Table: %EDIT_BU_IN

61 PO_POST_STATUS Character(1) VARCHAR2(1) NOT NULL Post Status
D=Distributed
N=None

Default Value: N

62 CLOSE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Close Amount
63 CLOSE_AMOUNT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Close Base Amount
64 QTY_REQ Number(16,4) DECIMAL(15,4) NOT NULL Requisition Quantity
65 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type
66 DISTRIB_PCT Number(8,4) DECIMAL(7,4) NOT NULL Distribution Percentage
67 INVOICE_CLOSE_IND Character(1) VARCHAR2(1) NOT NULL Invoice Close Indicator

Default Value: N

68 FINANCIAL_ASSET_SW Character(1) VARCHAR2(1) NOT NULL Capitalized Asset
N=Non Cap
Y=Capitalize

Default Value: N

69 COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type

Prompt Table: COST_TYPE_TBL

70 TAX_CD_SUT Character(8) VARCHAR2(8) NOT NULL Tax Code - Sales and Use Tax
71 TAX_CD_SUT_PCT Number(8,4) DECIMAL(7,4) NOT NULL Sales/Use Tax Code Percent
72 SALETX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Amount
73 SALETX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Sales Tax Amount
74 USETAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
75 USETAX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Use Tax Amount
76 SUT_APPLICABILITY Character(1) VARCHAR2(1) NOT NULL Sales/Use Tax Applicability
D=Direct Pay
E=Item is Exempt
S=Sales Tax Applicable
U=Use Tax Applicable
X=Purchaser Is Exonerated
77 VAT_TXN_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales.

Prompt Table: VAT_TXN_CD

78 VAT_APPLICABILITY Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not a transaction is eligible for VAT (Value Added Tax) taxation or why it is not eligible.
E=Exempt
N=Not Applicable
O=Outside of Scope of VAT
S=Suspended
T=Taxable
V=VAT Only
X=Exonerated
79 TAX_CD_VAT Character(8) VARCHAR2(8) NOT NULL Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.
80 TAX_CD_VAT_PCT Signed Number(9,4) DECIMAL(7,4) NOT NULL Specifies the tax percentage that corresponds to the VAT code. If more than one VAT authority is linked to a VAT code this will represent an aggregate percentage.
81 VAT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. In PeopleSoft Receivables this field is populated when the VAT declaration point is set to Invoice.
82 VAT_AMT_BASE Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. It is expressed in the base currency of the General Ledger business unit associated with the transaction. Refer to the definition for VAT_AMT.
83 VAT_BASIS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount on a sale (receivables item) or purchase (Payables voucher) transaction that is subject to VAT taxation. Depending on other parameters this amount may represent the gross or net amount of the transaction and may or may not include freight charges.
84 VAT_BASIS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Basis Amt in Base Curr
85 VAT_RECOVERY_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL VAT Recovery Percent
86 VAT_RCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Recovery Amt
87 VAT_RCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Recovery Amt in Base Curr
88 VAT_REBATE_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL VAT Rebate Percent
89 VAT_REBATE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Rebate Amt
90 VAT_REBATE_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Rebate Amt in Base Curr
91 VAT_USE_ID Character(6) VARCHAR2(6) NOT NULL VAT Use Type

Prompt Table: VAT_USE_TBL

92 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.

Prompt Table: RT_TYPE_TBL

93 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

Default Value: 1

94 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

Default Value: 1

95 FREIGHT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount
96 FREIGHT_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Freight Amount
97 FREIGHT_AMT_NP Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount
98 FREIGHT_AMT_NP_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Freight Amount
99 MISC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Misc. Amount
100 MISC_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Misc. Amount
101 MISC_AMT_NP Signed Number(28,3) DECIMAL(26,3) NOT NULL Misc. Amount
102 MISC_AMT_NP_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Misc. Amount
103 MONETARY_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
104 MONETARY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Monetary Amount - VCHR BU Base
105 BUDGET_DT Date(10) DATE Budget Date
106 BUDGET_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL -> SL - 15-AUG-2002 MISC_CRITERIA label has been added <-
B=Bypass
E=Error
N=Not Chk'd
V=Valid
W=Warning

Default Value: N

107 KK_CLOSE_FLAG Character(1) VARCHAR2(1) NOT NULL Commitment Control Close Flag

Y/N Table Edit

Default Value: N

108 KK_PROCESS_PRIOR Character(1) VARCHAR2(1) NOT NULL Process Prior Document

Y/N Table Edit

Default Value: N

109 VAT_CALC_TYPE Character(1) VARCHAR2(1) NOT NULL "A flag that indicates how VAT is stated and determines how the system performs the relevant VAT calculations. If ""Exclusive"", the VAT amount is stated separately from the merchandise amount. If ""Inclusive"", the VAT is not stated separately but is included with the merchandise amount."
E=Exclusive
I=Inclusive
110 SALETX_PRORATE_FLG Character(1) VARCHAR2(1) NOT NULL Prorate Sales Tax
111 USETAX_PRORATE_FLG Character(1) VARCHAR2(1) NOT NULL Prorate Use Tax
112 VAT_NRCVR_PRO_FLG Character(1) VARCHAR2(1) NOT NULL Prorate Non-Recoverable VAT
113 VAT_PRORATE_FLG Character(1) VARCHAR2(1) NOT NULL Prorate VAT
114 CONSIGNED_FLAG Character(1) VARCHAR2(1) NOT NULL Consigned Flag

Y/N Table Edit

Default Value: N

115 PEG_STATUS Character(2) VARCHAR2(2) NOT NULL 07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Not Pegged

Default Value: 40

116 VAT_RCVRY_PCT_SRC Character(1) VARCHAR2(1) NOT NULL VAT Recovery Percent Source
A=Automatically calculated
M=Manual Entry
117 VAT_REBATE_PCT_SRC Character(1) VARCHAR2(1) NOT NULL VAT Rebate Percent Source
A=Automatically calculated
M=Manual Entry
118 VAT_TRANS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents the sale or purchase amount against which the VAT is applicable.
119 VAT_TRANS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents the sale or purchase amount in base currency against which the VAT is applicable
120 PUBLISHED_IBU Character(5) VARCHAR2(5) NOT NULL Inventory Business Unit
121 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
122 KK_CLOSE_PRIOR Character(1) VARCHAR2(1) NOT NULL Close Prior Transaction

Default Value: N

123 DOC_TOL_LN_STATUS Character(1) VARCHAR2(1) NOT NULL Document Line Document Tolerance Status
E=Error
N=Not Checked
R=Reset
V=Valid

Default Value: V

124 ROLL_STAT_R Character(1) VARCHAR2(1) NOT NULL Rolled

Default Value: N

125 USER_DIST_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
126 CUSTOM_C100_D1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
127 CUSTOM_C100_D2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
128 CUSTOM_C100_D3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
129 CUSTOM_C100_D4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4
130 CUSTOM_DATE_D Date(10) DATE Custom Date
131 CUSTOM_C1_D Character(1) VARCHAR2(1) NOT NULL Custom Character 2
132 ENTRY_EVENT Character(10) VARCHAR2(10) NOT NULL Entry Event

Prompt Table: %EDIT_EE_EVENT
Set Control Field: BUSINESS_UNIT

133 QTY_PO_STD_EXP Number(16,4) DECIMAL(15,4) NOT NULL Expected PO Quantity Standard
134 ATTN_TO Character(30) VARCHAR2(30) NOT NULL Attention
135 VAT_RVRSE_CHG_GDS Character(1) VARCHAR2(1) NOT NULL VAT Reverse Charge goods flag
136 STATUS_DESCR Character(30) VARCHAR2(30) NOT NULL Status Description