| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 3 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 4 |
BUSINESS_UNIT_AP |
Character(5) |
VARCHAR2(5) NOT NULL |
AP Business Unit
|
| 5 |
BUSINESS_UNIT_PO |
Character(5) |
VARCHAR2(5) NOT NULL |
PO Business Unit
|
| 6 |
BUSINESS_UNIT_RECV |
Character(5) |
VARCHAR2(5) NOT NULL |
Receiving Business Unit
|
| 7 |
CM_BOOK |
Character(10) |
VARCHAR2(10) NOT NULL |
Cost Book
|
| 8 |
CM_DT_TIMESTAMP |
DateTime(26) |
TIMESTAMP |
Receipt dttm.
|
| 9 |
CM_DT_TIMESTAMP_A |
DateTime(26) |
TIMESTAMP |
07/99 GMG CN800-9.0: Original putaway dttm when bin-to-bin'd.
|
| 10 |
CM_SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 11 |
CM_SEQ_NBR_A |
Number(15,0) |
DECIMAL(15) NOT NULL |
07/99 GMG CN800-9.0:
|
| 12 |
CONVERSION_RATE |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Conversion Rate
|
| 13 |
CTL_GROSS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Control Gross Amount
|
| 14 |
CTL_VOUCHERS |
Number(6,0) |
INTEGER NOT NULL |
Control Voucher Number
|
| 15 |
DISTRIB_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Distribution Line
|
| 16 |
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
|
| 17 |
DT_TIMESTAMP |
DateTime(26) |
TIMESTAMP |
Date Timestamp
|
| 18 |
ECTRANSID |
Character(15) |
VARCHAR2(15) NOT NULL |
Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)
|
| 19 |
ERS_INV_SEQ |
Number(5,0) |
INTEGER NOT NULL |
ERS Invoice Sequence
|
| 20 |
FREIGHT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Freight Amount
|
| 21 |
GROSS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Invoice Amount
|
| 22 |
GRP_AP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Control Group ID
|
| 23 |
GRP_AP_ID_LASTUSED |
Number(10,0) |
DECIMAL(10) NOT NULL |
Group ID last assigned
|
| 24 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 25 |
INVOICE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Invoice Number
|
| 26 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
|
| 27 |
MERCH_AMT_TTL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
PO Total Value
|
| 28 |
MERCHANDISE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Merchandise Amt
F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
|
| 29 |
MISC_CHRG_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Misc Charge Amount
|
| 30 |
MISC_CHARGE_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
|
| 31 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 32 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
|
| 33 |
PACKSLIP_NO |
Character(22) |
VARCHAR2(22) NOT NULL |
Packing Slip Number
|
| 34 |
PROCESS_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process
N=Don't Run
O=Process Once
|
| 35 |
PYMNT_GROSS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Payment Amount
|
| 36 |
PYMNT_CNT |
Number(5,0) |
INTEGER NOT NULL |
Payments
|
| 37 |
RECEIPT_UM |
Character(3) |
VARCHAR2(3) NOT NULL |
Receiving UOM
|
| 38 |
RECEIVER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Receiver number
|
| 39 |
RECV_LN_NBR |
Number(5,0) |
INTEGER NOT NULL |
Receipt Line
|
| 40 |
RECV_SHIP_SEQ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Receiver Shipping Sequence
|
| 41 |
REQUEST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Request ID
|
| 42 |
RTV_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Return To Vendor ID
|
| 43 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 44 |
SALETX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Sales Tax Amount
|
| 45 |
SCHED_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Schedule Number
|
| 46 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 47 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 48 |
TEMP_VALUE |
Character(18) |
VARCHAR2(18) NOT NULL |
Temporary Query Value
|
| 49 |
UNIT_MEASURE_STD |
Character(3) |
VARCHAR2(3) NOT NULL |
Standard Unit of Measure
|
| 50 |
VAT_ENTRD_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Entered VAT Amount
|
| 51 |
VCHR_BLD_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Voucher Build Code
|
| 52 |
VCHR_BLD_DFLT_PASS |
Character(1) |
VARCHAR2(1) NOT NULL |
Bypass delivered defaulting
|
| 53 |
VCHR_BLD_ERRORS |
Number(5,0) |
INTEGER NOT NULL |
Voucher Build Errors
|
| 54 |
VCHR_BLD_HDR_CLS1 |
Character(100) |
VARCHAR2(100) NOT NULL |
Header Where Clause
|
| 55 |
VCHR_BLD_MATCH_CON |
Character(1) |
VARCHAR2(1) NOT NULL |
Voucher Build Continue Flag
|
| 56 |
VCHR_BLD_RCV_FRM1 |
Character(50) |
VARCHAR2(50) NOT NULL |
Receiver From Clause 1
|
| 57 |
VCHR_COUNT |
Number(6,0) |
INTEGER NOT NULL |
Count of Vouchers
|
| 58 |
VCHR_NUM_LAST_USED |
Number(8,0) |
INTEGER NOT NULL |
Last Voucher Number
|
| 59 |
VCHR_SRC |
Character(4) |
VARCHAR2(4) NOT NULL |
Voucher Source
|
| 60 |
VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
|
| 61 |
VOUCHER_ID_RELATED |
Character(8) |
VARCHAR2(8) NOT NULL |
Related Voucher
|
| 62 |
VOUCHER_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Voucher Line Number
|
| 63 |
VCHR_BLD_KEY_C1 |
Character(25) |
VARCHAR2(25) NOT NULL |
Voucher Build Key Char 1
|
| 64 |
VCHR_BLD_KEY_C2 |
Character(25) |
VARCHAR2(25) NOT NULL |
Voucher Build Key Char 1
|
| 65 |
VCHR_BLD_KEY_N1 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Voucher Build Key Num 1
|
| 66 |
VCHR_BLD_KEY_N2 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Vchr Build Key Num 2
|
| 67 |
CNTRCT_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Buying Agreement ID
|
| 68 |
CNTRCT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 69 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 70 |
RELEASE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Release Type
P=Purchase Order
V=Voucher
|
| 71 |
VCHR_BLD_CNT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Contract Voucher Action
B=Build Voucher
T=Stage Voucher
|
| 72 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 73 |
TO_CUR |
Character(3) |
VARCHAR2(3) NOT NULL |
To Currency Code
|
| 74 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
|
| 75 |
INVOICE_DT |
Date(10) |
DATE |
Invoice Date
|
| 76 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 77 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 78 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
|
| 79 |
BANK_ACCT_KEY |
Character(4) |
VARCHAR2(4) NOT NULL |
A user defined unique identifier that facilitates the identification of a given account with a given bank
|
| 80 |
PYMNT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Payment Number
|
| 81 |
LAST_PYMNT_ID_USED |
Number(10,0) |
DECIMAL(10) NOT NULL |
Last Payment Id
|
| 82 |
PYMNT_ID_REF |
Character(20) |
VARCHAR2(20) NOT NULL |
Payment Reference
|
| 83 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
|
| 84 |
DYN_UPDATE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Dynamic Update Clause Flag
|
| 85 |
NEW_SRC_SELECT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
New Voucher Data Selected
|
| 86 |
RCY_SRC_SELECT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Recycled Vouchers Available
|
| 87 |
ORIGIN |
Character(3) |
VARCHAR2(3) NOT NULL |
Origin
|
| 88 |
VCHR_BATCH_INT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Process all Interfaces?
|
| 89 |
VCHR_PROC_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Option
A=Process All Units
B=Business Unit
C=Process Contract
E=Process Supplier
G=Process Group
O=Process Origin
P=Process Payment Request
V=Process Voucher
|
| 90 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 91 |
SQLID |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE
SQLTYPE = 0: SQL object name
SQLTYPE = 1: Application Engine Step Identifier
SQLTYPE = 2: RECNAME
SQLTYPE = 6: Application Engine XSLT (XML definition)
|
| 92 |
ERROR_COUNT |
Number(9,0) |
DECIMAL(9) NOT NULL |
Error Count
|
| 93 |
VED_RUN_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Voucher Edit Run Status
E=Edit Errors Logged
N=No Data Selected
P=All Edits Passed
|
| 94 |
NEW_VCH_SELECT_CNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
New Voucher Select Count
|
| 95 |
RCY_VCH_SELECT_CNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Recycled Voucher Select Count
|
| 96 |
SELECT_COUNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
SQL Select Count
|
| 97 |
ERS_TAX_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
ERS Tax Type
B=Sales Tax
N=No Taxes
U=Use Tax
V=Value Added Tax
|
| 98 |
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
|
| 99 |
CF_ATTRIB_VALUE |
Character(20) |
VARCHAR2(20) NOT NULL |
ChartField Attribute Value
|
| 100 |
LINE_VCHR_PCT |
Signed Number(29,20) |
DECIMAL(27,20) NOT NULL |
Line Voucher Ratio
|
| 101 |
TRANS_DATE |
Date(10) |
DATE |
Transaction Date
|
| 102 |
RECV_DIST_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Receiver Distrib Line
|
| 103 |
BUSINESS_UNIT_AM |
Character(5) |
VARCHAR2(5) NOT NULL |
AM Business Unit
|
| 104 |
PROFILE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Profile ID
|
| 105 |
AUTO_ASSIGN_INV |
Character(1) |
VARCHAR2(1) NOT NULL |
Assign Invoice ID
|
| 106 |
AUTO_ASSIGN_INV_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Assign Invoice Date
|
| 107 |
URL |
Character(254) |
VARCHAR2(254) NOT NULL |
Internet URL (Universal Resource Locator)
|
| 108 |
AP_VCHR_AIA_GUID |
Character(36) |
VARCHAR2(36) NOT NULL |
Voucher GUID from AIA
|
| 109 |
COST_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost Type
|
| 110 |
SPENDING_REGION |
Character(30) |
VARCHAR2(30) NOT NULL |
Spending Region
|
| 111 |
SPNDNG_REG_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Spending Region Edit Option
1=No Edit
2=Required
3=Optional
4=Prohibited
|
| 112 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 113 |
DECIMAL_POSITIONS |
Number(2,0) |
SMALLINT NOT NULL |
Decimal Positions
|
| 114 |
SHIPTO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship To Location
|
| 115 |
SUT_BASE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Sales/Use Tax Destination
|
| 116 |
TAX_CD_SUT |
Character(8) |
VARCHAR2(8) NOT NULL |
Tax Code - Sales and Use Tax
|
| 117 |
SUT_EXCPTN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales/Use Tax Exception Type
D=Direct Pay
E=Exempt/Exonerated
N=None
|
| 118 |
SUT_EXCPTN_CERTIF |
Character(20) |
VARCHAR2(20) NOT NULL |
Sales/Use Tax Exception Certif
|
| 119 |
ULTIMATE_USE_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Ultimate Use Code
|
| 120 |
ASSIGNED_TO_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Assigned to
|
| 121 |
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.
|
| 122 |
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.
|
| 123 |
VAT_USE_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
VAT Use Type
|
| 124 |
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
|
| 125 |
VAT_TREATMENT |
Character(4) |
VARCHAR2(4) NOT NULL |
VAT Treatment
|
| 126 |
PYMNT_TERMS_CD_PPY |
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.
|
| 127 |
FROM_DT |
Date(10) |
DATE |
From Date
|
| 128 |
TO_DT |
Date(10) |
DATE |
To Date
|
| 129 |
PO_DIST_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
PO Distribution Line Number
|
| 130 |
PREV_VCHR_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Previous Voucher Line Number
|
| 131 |
BUSINESS_UNIT_WO |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit Work Order
Prompt Table:
SP_BU_WM_NONVW
|
| 132 |
WO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Work Order Identification
Prompt Table:
%EDIT_WO_ID
|
| 133 |
WO_TASK_ID |
Number(5,0) |
INTEGER NOT NULL |
Task Number
Prompt Table:
%EDIT_WO_TASK
|
| 134 |
RSRC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Order Management Resource Types
1=Labor
2=Tools
3=Material
|
| 135 |
RES_LN_NBR |
Number(5,0) |
INTEGER NOT NULL |
Resource Line No.
Prompt Table:
%EDIT_RES_LINE
|
| 136 |
MFG_ITM_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
Manufacturer's Item ID
|
| 137 |
PYMNT_MESSAGE_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Message Code
|
| 138 |
QTY_VCHR |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity Vouchered
|
| 139 |
SCHEDULED_PAY_DT |
Date(10) |
DATE |
Scheduled to Pay
|
| 140 |
LENGTH |
Number(5,0) |
INTEGER NOT NULL |
Length
|
| 141 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
|
| 142 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
|
| 143 |
ITM_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Item SetID
|
| 144 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
|
| 145 |
POST_STATUS_AP |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Status
N=Payment Not Applied
P=Posted
U=Unposted
|
| 146 |
BUDGET_HDR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Checking Header Status
E=Error in Budget Check
I=Document In Processing
N=Not Budget Checked
P=Provisionally Valid
V=Valid
|
| 147 |
MATCH_LINE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Match Line Option
E=ERS
F=Full Match
N=Don't Match
|
| 148 |
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.
|
| 149 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
|
| 150 |
ERS_INV_DT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
ERS Invoice Date Option
F=Frt Terms
R=Recv Date
|
| 151 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
|
| 152 |
LEASE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Lease ID
|
| 153 |
LEASE_PYMNT_DT |
Date(10) |
DATE |
Lease Payment Date
|
| 154 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 155 |
STATISTICS_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Statistics Code
|
| 156 |
RTV_LN_NBR |
Number(5,0) |
INTEGER NOT NULL |
Return To Vendor Line
|
| 157 |
ITEM |
Character(30) |
VARCHAR2(30) NOT NULL |
Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.
|
| 158 |
ITEM_LINE |
Number(6,0) |
INTEGER NOT NULL |
Item Line
|
| 159 |
DISTRIB_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Distribution Sequence
|
| 160 |
GWA_REPORTER |
Character(1) |
VARCHAR2(1) NOT NULL |
GWA Reporter Validation field
|
| 161 |
VAT_NRCVR_CHRG_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
ProrateVAT Non-Recovery
|
| 162 |
PRORATE |
Character(1) |
VARCHAR2(1) NOT NULL |
05/19/99 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
|
| 163 |
PR_REQUEST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Payment Request Id
|
| 164 |
REMIT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Remit SetID
|
| 165 |
REMIT_VENDOR |
Character(10) |
VARCHAR2(10) NOT NULL |
Remit Vendor
|
| 166 |
REMIT_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Remit to Location
|
| 167 |
TOTAL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Amount
|
| 168 |
PYMNT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Payment Amount
|
| 169 |
CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
|
| 170 |
ITEM_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Item Sequence Number
|
| 171 |
PREPAID_AUTO_APPLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Automatically Apply Prepayment
|
| 172 |
HSN_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
HSN Code for GST
|
| 173 |
SAC_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
SAC Code
|
| 174 |
MFG_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
Manufacturer ID
|
| 175 |
UPN_TYPE_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Universal Product Number Format Type
|
| 176 |
UPN_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Universal Product Number
|
| 177 |
EXD_TAX_ITEM_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Tax Item Type
C=Capital Goods
F=Finished Goods
R=Raw Material
S=Service
|
| 178 |
DESCR254_MIXED |
Character(254) |
VARCHAR2(254) NOT NULL |
Description
|
| 179 |
REVERSE_CHARGE_GST |
Character(1) |
VARCHAR2(1) NOT NULL |
Reverse Charge Applicable Flag
|
| 180 |
AE_APPSTATUS |
Number(1,0) |
SMALLINT NOT NULL |
AE Application Warning Status
|