| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BATCH_SEQ_NUM |
Number(15,0) |
DECIMAL(15) NOT NULL |
Batch Number
|
| 2 |
VH_SEQ_NUM |
Number(15,0) |
DECIMAL(15) NOT NULL |
Data Sequence Number
|
| 3 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BU_AP_NONVW
|
| 4 |
VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
|
| 5 |
INVOICE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Invoice Number
|
| 6 |
INVOICE_DT |
Date(10) |
DATE |
Invoice Date
|
| 7 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
Default Value: VENDOR.SETID
|
| 8 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
VNDR_ACTIVE_VW
|
| 9 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
Prompt Table:
VNDR_LOC_AP_VW
|
| 10 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
Prompt Table:
VNDR_ADD2_AP_VW
|
| 11 |
REMIT_ADDR_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Remitting Location
Prompt Table:
VNDR_ADD2_AP_VW
|
| 12 |
GRP_AP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Control Group ID
Prompt Table:
GRP_AP_OPR_VW2
|
| 13 |
ORIGIN |
Character(3) |
VARCHAR2(3) NOT NULL |
Origin
Prompt Table:
ORIGIN_AP
|
| 14 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 15 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 16 |
DST_CNTRL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Accounting Template
Prompt Table:
DST_CNTRL_VW
|
| 17 |
VOUCHER_ID_RELATED |
Character(8) |
VARCHAR2(8) NOT NULL |
Related Voucher
|
| 18 |
GROSS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Invoice Amount
|
| 19 |
DSCNT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount Amount
|
| 20 |
SALETX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Sales Tax Amount
|
| 21 |
FREIGHT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Freight Amount
|
| 22 |
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.
Prompt Table:
PYMT_TR_EFF_VW
|
| 23 |
TXN_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
Default Value: OPR_DEF_TBL_AP.CURRENCY_CD
Prompt Table:
CURR_TXN_VW
|
| 24 |
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
|
| 25 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 26 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 27 |
VAT_ENTRD_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Entered VAT Amount
|
| 28 |
MATCH_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Match Action
N=No Match
Y=Standard
|
| 29 |
MATCH_STATUS_VCHR |
Character(1) |
VARCHAR2(1) NOT NULL |
Match Status
C=Overridden - Credit Note
D=Match Dispute
E=Match Exceptions Exist
M=Matched
N=Not Applicable
O=Manually Overridden
T=To Be Matched
|
| 30 |
CUR_RT_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Exchange Rate Source
T=Use Exchange Rate Tables
U=User Specified
|
| 31 |
DSCNT_AMT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Discount Amount Control
T=Controlled by Payment Terms
U=User Specified
|
| 32 |
DUE_DT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Due Date Control
T=Controlled by Terms
U=User Specified
|
| 33 |
DUE_DT |
Date(10) |
DATE |
Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
|
| 34 |
DSCNT_DUE_DT |
Date(10) |
DATE |
Discount Due Date
|
| 35 |
VAT_DCLRTN_POINT |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that specifies when VAT information for sales or purchase transaction is recognized for reporting to the appropriate VAT authority. VAT is declared at invoice time, delivery time, accounting date or the time of payment.
A=At Accounting Date
D=At Delivery Time
I=At Invoice Time
P=At Payment Time
|
| 36 |
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
|
| 37 |
VAT_RECOVERY_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
VAT Recovery Percent
|
| 38 |
VAT_CALC_GROSS_NET |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether VAT calculation should be done on the Gross (G) amount or on the Net (N) amount of sales or purchase transaction. When calculating VAT at net the early payment discount is applied to the goods amount before calculating the VAT. When calculating VAT at gross the VAT is initially calculated based on the gross transaction amount.
G=Calculate at Gross
N=Calculate at Net
|
| 39 |
VAT_RECALC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not the VAT discount amount is recalculated at payment time. This field is only used if the VAT Calculation Type (VAT_CAL_GROSS_NET) is gross.
|
| 40 |
VAT_CALC_FRGHT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Freight
|
| 41 |
VAT_RGSTRN_SELLER |
Character(20) |
VARCHAR2(20) NOT NULL |
Seller's VAT Registration
|
| 42 |
VAT_NRCVR_CHRG_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
ProrateVAT Non-Recovery
|
| 43 |
COUNTRY_SHIP_FROM |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country from which the invoice contents were shipped (for VAT processing only).
Prompt Table:
COUNTRY_TBL
|
| 44 |
STATE_SHIP_FROM |
Character(6) |
VARCHAR2(6) NOT NULL |
Ship From State
|
| 45 |
COUNTRY_SHIP_TO |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country to which the invoice contents were shipped (for VAT processing only).
Prompt Table:
COUNTRY_TBL
|
| 46 |
STATE_SHIP_TO |
Character(6) |
VARCHAR2(6) NOT NULL |
Ship To State
|
| 47 |
COUNTRY_LOC_SELLER |
Character(3) |
VARCHAR2(3) NOT NULL |
Seller's Location Country - May be either the VAT Entity or the Trading Partner
|
| 48 |
STATE_LOC_SELLER |
Character(6) |
VARCHAR2(6) NOT NULL |
Seller's Location State - May be either the VAT Entity or the Trading Partner
|
| 49 |
COUNTRY_LOC_BUYER |
Character(3) |
VARCHAR2(3) NOT NULL |
Buyer's Location Country - May be either the VAT Entity or the Trading Partner
|
| 50 |
STATE_LOC_BUYER |
Character(6) |
VARCHAR2(6) NOT NULL |
Buyer's Location State - May be either the VAT Entity or the Trading Partner
|
| 51 |
COUNTRY_VAT_BILLFR |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country where an invoice is generated (for VAT processing only).
Prompt Table:
COUNTRY_TBL
|
| 52 |
COUNTRY_VAT_BILLTO |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country where an invoice is sent (for VAT processing only).
Prompt Table:
COUNTRY_TBL
|
| 53 |
COUNTRY_VAT_SUPPLY |
Character(3) |
VARCHAR2(3) NOT NULL |
VAT Place of Supply Country
|
| 54 |
STATE_VAT_SUPPLY |
Character(6) |
VARCHAR2(6) NOT NULL |
VAT Place of Supply State
|
| 55 |
COUNTRY_VAT_PERFRM |
Character(3) |
VARCHAR2(3) NOT NULL |
Country Where Service Physically Performed
|
| 56 |
STATE_VAT_PERFRM |
Character(6) |
VARCHAR2(6) NOT NULL |
State Where Service Physically Performed
|
| 57 |
STATE_VAT_DEFAULT |
Character(6) |
VARCHAR2(6) NOT NULL |
VAT Defaulting State
|
| 58 |
VAT_EXCPTN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that specifies the reason for a VAT exemption for a customer. Suspension (S) and Exoneration (X) are examples of Exception Type.
N=None
S=Suspended
X=Exonerated
|
| 59 |
VAT_EXCPTN_CERTIF |
Character(20) |
VARCHAR2(20) NOT NULL |
Specifies the VAT exception certificate number. This identifier serves as proof of customer's exemption from VAT.
|
| 60 |
DESCR254_MIXED |
Character(254) |
VARCHAR2(254) NOT NULL |
Description
|
| 61 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 62 |
BUSINESS_UNIT_PO |
Character(5) |
VARCHAR2(5) NOT NULL |
PO Business Unit
Prompt Table:
SP_BU_PM_NONVW
|
| 63 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
Prompt Table:
%EDIT_VCHR_PO
|
| 64 |
BILL_OF_LADING |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies a bill of lading number associated with a Receivables item.
|
| 65 |
CARRIER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Carrier ID
|
| 66 |
PACKSLIP_NO |
Character(22) |
VARCHAR2(22) NOT NULL |
Packing Slip Number
|
| 67 |
MISC_CHRG_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Misc Charge Amount
|
| 68 |
SHIP_DATE |
Date(10) |
DATE |
Item Shipping Date
|
| 69 |
RECEIPT_DT |
Date(10) |
DATE |
Received Date
|
| 70 |
RECEIPT_DOC_DT |
Date(10) |
DATE |
Received Doc Date
|
| 71 |
BUSINESS_UNIT_RECV |
Character(5) |
VARCHAR2(5) NOT NULL |
Receiving Business Unit
Prompt Table:
SP_BU_PM_NONVW
|
| 72 |
RECEIVER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Receiver number
|
| 73 |
IN_PROCESS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
In process flag
Default Value: N
|
| 74 |
VCHR_BLD_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Voucher Build Code
Prompt Table:
VCHR_BLD_CD_VW2
|
| 75 |
TAX_EXEMPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt Flag
|
| 76 |
VAT_CALC_MISC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Miscellaneous
|
| 77 |
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
|
| 78 |
VCHR_BLD_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Build Status
B=Build Voucher
D=Delete Voucher
E=Pre-Edit Error
H=Tolerance Hold
I=Initiated
N=Not processed
S=Voucher Staged
T=Stage Voucher
Default Value: B
|
| 79 |
DTTM_CREATED |
DateTime(26) |
TIMESTAMP |
Datetime Created
|
| 80 |
DTTM_MODIFIED |
DateTime(26) |
TIMESTAMP |
Datetime modified
|
| 81 |
DTTM_PROCESSED |
DateTime(26) |
TIMESTAMP |
Datetime processed
|
| 82 |
VCHR_BLD_COUNT |
Number(3,0) |
SMALLINT NOT NULL |
Build Process Count
Default Value: 0
|
| 83 |
VCHR_BLD_PAY_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Prepayment Option
N=No
P=Prepay Voucher
V=Prepayment Created
Default Value: N
|
| 84 |
VCHR_PREPAY_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Prepay Amount
|
| 85 |
PRO_NUMBER |
Character(40) |
VARCHAR2(40) NOT NULL |
Pro Number
|
| 86 |
VCHR_BLD_ERROR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Voucher Build Error Flag
Y/N Table Edit
Default Value: N
|
| 87 |
VOUCHER_STYLE |
Character(4) |
VARCHAR2(4) NOT NULL |
Voucher Style
ADJ=Adjustments
AMR=Amortization Voucher
CLBK=Claim Voucher
CORR=Reversal Voucher
JRNL=Journal Voucher
PPAY=Prepaid Voucher
REG=Regular Voucher
RGTR=Register Voucher
SGLP=Single Payment Voucher
THRD=Third Party Voucher
TMPL=Template Voucher
Default Value: REG
|
| 88 |
INSPECT_DT |
Date(10) |
DATE |
Inspection Date
|
| 89 |
INV_RECPT_DT |
Date(10) |
DATE |
Invoice Receipt Date
|
| 90 |
IMAGE_DATE |
Date(10) |
DATE |
Image Date
|
| 91 |
IMAGE_REF_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Image Reference ID
|
| 92 |
PAY_SCHEDULE_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Schedule Type
MAN=Manual
OTH=Other Non Transportation
TRN=Transportation
|
| 93 |
VCHR_APPRVL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Voucher Approval Flag
D=Default from Higher Level
P=Pre-Approved
S=Virtual Approver
W=Approval Framework
|
| 94 |
APPR_RULE_SET |
Character(30) |
VARCHAR2(30) NOT NULL |
Approval Rule Set
|
| 95 |
BUSPROCNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Business Process Name (see PSBUSPROCDEFN).
|
| 96 |
LC_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Treasury Letter of Credit Number Assigned by the System
|
| 97 |
POST_VOUCHER |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Voucher Now
D=Post Later
N=Do Not Post
P=Post Immediately
Default Value: D
|
| 98 |
DOC_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
|
| 99 |
DSCNT_PRORATE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Prorate Discount
|
| 100 |
VCHR_SRC |
Character(4) |
VARCHAR2(4) NOT NULL |
Voucher Source
Default Value: QUCK
|
| 101 |
MISC_CHARGE_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
Prompt Table:
VCHR_MISC_CD_VW
|
| 102 |
FRGHT_CHARGE_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
Prompt Table:
VCHR_FRG_CD_VW
|
| 103 |
SALETX_CHARGE_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
Prompt Table:
VCHR_STX_CD_VW
|
| 104 |
CNTRCT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 105 |
CNTRCT_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Buying Agreement ID
|
| 106 |
VERSION_NBR |
Number(5,0) |
INTEGER NOT NULL |
Contract Version number
Default Value: 1
|
| 107 |
ECQUEUEINSTANCE |
Number(9,0) |
DECIMAL(9) NOT NULL |
Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
|
| 108 |
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)
|
| 109 |
ECTRANSINOUTSW |
Character(1) |
VARCHAR2(1) NOT NULL |
Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound.
I=Inbound
O=Outbound
|
| 110 |
EIN_FEDERAL |
Character(9) |
VARCHAR2(9) NOT NULL |
EIN Federal
|
| 111 |
EIN_STATE_LOCAL |
Character(20) |
VARCHAR2(20) NOT NULL |
EIN State Local
|
| 112 |
ERS_INV_SEQ |
Number(5,0) |
INTEGER NOT NULL |
ERS Invoice Sequence
|
| 113 |
ERS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
ERS Type
N=Not Applicable
P=PO Receipt
R=Non PO Receipt
|
| 114 |
PREPAID_AUTO_APPLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Automatically Apply Prepayment
Default Value: Y
|
| 115 |
PREPAID_REF |
Character(10) |
VARCHAR2(10) NOT NULL |
Prepayment Reference
|
| 116 |
TAX_GRP |
Character(4) |
VARCHAR2(4) NOT NULL |
Tax Group Code
|
| 117 |
TAX_PYMNT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Tax Payment Type Code
|
| 118 |
VAT_CF_ANLSYS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Chartfield Analysis
E=Use Expense Line Chartfields
N=Not Applicable
V=Use VAT Accounting Chartfields
|
| 119 |
VAT_ROUND_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
" Rounding rule to be applied to VAT calculations. Options are 'Natural'
D=Round Down
N=Natural Round
U=Round Up
|
| 120 |
VAT_TREATMENT_GRP |
Character(4) |
VARCHAR2(4) NOT NULL |
VAT Treatment Group
|
| 121 |
VOUCHER_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Voucher Type
A=Adjustment Voucher
B=Batch Edit Voucher
C=Recurring Voucher
E=ERS Voucher
J=Journal Voucher
N=Reversal Voucher
P=Prepaid Voucher
R=Regular Voucher
T=Third Party Voucher
V=Registered Voucher
X=Template Voucher
|
| 122 |
VCHR_TTL_LINES |
Number(5,0) |
INTEGER NOT NULL |
Lines Entered
|
| 123 |
TOTAL_DISTRIBS |
Number(5,0) |
INTEGER NOT NULL |
Total Number of Distributions
|
| 124 |
BUSINESS_UNIT_AR |
Character(5) |
VARCHAR2(5) NOT NULL |
AR Business Unit
|
| 125 |
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.
|
| 126 |
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.
|
| 127 |
ITEM_LINE |
Number(6,0) |
INTEGER NOT NULL |
Item Line
|
| 128 |
VCHR_QV_TEMPLATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Quick Invoice Template
C=Complete
M=Summary
S=Simple
Default Value: C
|
| 129 |
REQUESTOR_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Requestor id
|
| 130 |
LS_KEY |
Number(15,0) |
DECIMAL(15) NOT NULL |
Lease Key, Unique Key
|
| 131 |
TERMS_BASIS_DT |
Date(10) |
DATE |
Payment Terms Basis Date
|
| 132 |
USER_VCHR_CHAR1 |
Character(1) |
VARCHAR2(1) NOT NULL |
User Character Field
|
| 133 |
USER_VCHR_CHAR2 |
Character(1) |
VARCHAR2(1) NOT NULL |
User Character Field 2
|
| 134 |
USER_VCHR_DEC |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
User Amount Field
|
| 135 |
USER_VCHR_DATE |
Date(10) |
DATE |
User Date
|
| 136 |
USER_VCHR_NUM1 |
Number(3,0) |
SMALLINT NOT NULL |
User Number field
|
| 137 |
USER_HDR_CHAR1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Custom Character 1
|
| 138 |
CUSTOM_C100_A1 |
Character(100) |
VARCHAR2(100) NOT NULL |
Custom Field 1
|
| 139 |
CUSTOM_C100_A2 |
Character(100) |
VARCHAR2(100) NOT NULL |
Custom Field 2
|
| 140 |
CUSTOM_C100_A3 |
Character(100) |
VARCHAR2(100) NOT NULL |
Custom Field 3
|
| 141 |
CUSTOM_C100_A4 |
Character(100) |
VARCHAR2(100) NOT NULL |
Custom Field 4
|
| 142 |
CUSTOM_DATE_A |
Date(10) |
DATE |
Custom Date
|
| 143 |
CUSTOM_C1_A |
Character(1) |
VARCHAR2(1) NOT NULL |
Custom Character 2
|
| 144 |
MATCH_CNTRL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Match Rule
|
| 145 |
BUSINESS_UNIT_AM |
Character(5) |
VARCHAR2(5) NOT NULL |
AM Business Unit
|
| 146 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
|
| 147 |
LEASE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Lease ID
|
| 148 |
LEASE_PYMNT_DT |
Date(10) |
DATE |
Lease Payment Date
|
| 149 |
CLAIM_NO |
Character(30) |
VARCHAR2(30) NOT NULL |
Claim Number for an item
|
| 150 |
POLICY_NUM |
Character(30) |
VARCHAR2(30) NOT NULL |
Policy Information
|
| 151 |
ENDORSER_PARTY |
Character(40) |
VARCHAR2(40) NOT NULL |
Endorser Party
|
| 152 |
BUSINESS_UNIT_BI |
Character(5) |
VARCHAR2(5) NOT NULL |
Billing Business Unit
|
| 153 |
BI_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Billing Invoice number
|