A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
BUSINESS_UNITVOUCHER_LINE_NUMDISTRIB_LINE_NUMC=Closed Item
N=Not an Open Item Account
O=Open Item
VCHR_DIST_EC_FL(SQL Table) |
Index Back |
|---|---|
EC Voucher Dist Line Work Doc |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | AUDIT_ACTN | Character(1) | VARCHAR2(1) NOT NULL |
Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values |
| 2 | ROW_ID | Character(3) | VARCHAR2(3) NOT NULL | Row ID |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 5 | VOUCHER_LINE_NUM |
Number(5,0) | INTEGER NOT NULL | Voucher Line Number |
| 6 | DISTRIB_LINE_NUM |
Number(5,0) | INTEGER NOT NULL | Distribution Line |
| 7 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 8 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL | Account |
| 9 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 10 | STATISTICS_CODE | Character(3) | VARCHAR2(3) NOT NULL | Statistics Code |
| 11 | 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. |
| 12 | QTY_VCHR | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity Vouchered |
| 13 | JRNL_LN_REF | Character(10) | VARCHAR2(10) NOT NULL | Identifies a document, person, invoice, date, or any other piece of information that is associated with a journal line. It can be manually entered, or be defaulted from an accounting entry definition or from a Journal Generator Template. The journal line reference is optional, but helpful if you need to trace back to the source of the transaction. |
| 14 | OPEN_ITEM_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Open Item Status
C=Closed Item N=Not an Open Item Account O=Open Item |
| 15 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 16 | MERCHANDISE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label |
| 17 | BUSINESS_UNIT_PO | Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
| 18 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 19 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 20 | SCHED_NBR | Number(3,0) | SMALLINT NOT NULL | Schedule Number |
| 21 | PO_DIST_LINE_NUM | Number(5,0) | INTEGER NOT NULL | PO Distribution Line Number |
| 22 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 23 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 24 | ANALYSIS_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Analysis Type |
| 25 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Source Type |
| 26 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | Category |
| 27 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL | Subcategory |
| 28 | ASSET_FLG | Character(1) | VARCHAR2(1) NOT NULL | Assets Applicable |
| 29 | BUSINESS_UNIT_AM | Character(5) | VARCHAR2(5) NOT NULL | AM Business Unit |
| 30 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 31 | PROFILE_ID | Character(10) | VARCHAR2(10) NOT NULL | Asset Profile ID |
| 32 | FREIGHT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Freight Amount |
| 33 | SALETX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Sales Tax Amount |
| 34 | USETAX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 35 | 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. |
| 36 | VAT_INV_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Invoice Amount |
| 37 | VAT_NONINV_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Non-Invoice Amount |
| 38 | BUSINESS_UNIT_RECV | Character(5) | VARCHAR2(5) NOT NULL | Receiving Business Unit |
| 39 | RECEIVER_ID | Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 40 | RECV_LN_NBR | Number(5,0) | INTEGER NOT NULL | Receipt Line |
| 41 | RECV_SHIP_SEQ_NBR | Number(3,0) | SMALLINT NOT NULL | Receiver Shipping Sequence |
| 42 | RECV_DIST_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Receiver Distrib Line |
| 43 | OPERATING_UNIT | Character(8) | VARCHAR2(8) NOT NULL | Operating Unit ChartField |
| 44 | PRODUCT | Character(6) | VARCHAR2(6) NOT NULL | Product ChartField |
| 45 | FUND_CODE | Character(5) | VARCHAR2(5) NOT NULL | Fund Code |
| 46 | CLASS_FLD | Character(5) | VARCHAR2(5) NOT NULL | Class Field |
| 47 | PROGRAM_CODE | Character(5) | VARCHAR2(5) NOT NULL | Program Code ChartField |
| 48 | BUDGET_REF | Character(8) | VARCHAR2(8) NOT NULL | Budget Reference |
| 49 | AFFILIATE | Character(5) | VARCHAR2(5) NOT NULL | Affiliate |
| 50 | AFFILIATE_INTRA1 | Character(10) | VARCHAR2(10) NOT NULL | IntraUnit Affiliate1 |
| 51 | AFFILIATE_INTRA2 | Character(10) | VARCHAR2(10) NOT NULL | Operating Unit Affiliate |
| 52 | CHARTFIELD1 | Character(10) | VARCHAR2(10) NOT NULL | Expansion chartfield 1 |
| 53 | CHARTFIELD2 | Character(10) | VARCHAR2(10) NOT NULL | Expansion Chartfield 2 |
| 54 | CHARTFIELD3 | Character(10) | VARCHAR2(10) NOT NULL | Expansion Chartfield 3 |
| 55 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 56 | OPEN_ITEM_KEY | Character(30) | VARCHAR2(30) NOT NULL | Open Item Key |