| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 TEST_CASE |
Character(30) |
VARCHAR2(30) NOT NULL |
BTF Test Case
|
| 2 |
TRN_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Transfer Business Unit
|
| 3 |
TRN_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Transfer Worksheet ID
|
| 4 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 5 |
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.
|
| 6 |
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.
|
| 7 |
ITEM_LINE |
Number(6,0) |
INTEGER NOT NULL |
Item Line
|
| 8 |
WS_SEQ |
Number(6,0) |
INTEGER NOT NULL |
Worksheet Sequence Number
|
| 9 |
ITEM_SELECTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Item selected switch
|
| 10 |
ENTRY_USE_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the System Function or type of processing associated with an entry type.
|
| 11 |
ENTRY_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the type of transaction associated with a pending item. The entry type remains with the item after it is posted and affects many areas of Receivables processing. Some examples of entry types are Invoices Credit Memo Prepayment and Deduction.
Prompt Table:
ENTRY_TYPE_TBL
|
| 12 |
ENTRY_REASON |
Character(5) |
VARCHAR2(5) NOT NULL |
"Specifies an entry reason that further qualifies the entry type associated with a pending item. For example an entry reason for a credit memo might be ""Pricing Error"" or ""Shipping Error""."
Prompt Table:
AUTO_REASN_VW
|
| 13 |
ENTRY_EVENT |
Character(10) |
VARCHAR2(10) NOT NULL |
Entry Event
Prompt Table:
EE_AR_CODE1_VW
|
| 14 |
REF_REASON |
Character(5) |
VARCHAR2(5) NOT NULL |
Reference Reason
|
| 15 |
REQUIRE_REASON |
Character(1) |
VARCHAR2(1) NOT NULL |
Require Reason
|
| 16 |
BAL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Item Balance
|
| 17 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 18 |
ASOF_DT |
Date(10) |
DATE |
As of Date
|
| 19 |
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.
|
| 20 |
PO_REF |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the purchase order number associated with a receivables item.
|
| 21 |
DOCUMENT |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies a document used as a reference number for a Receivables item. Document ID is used by the Receivables Update program and the Maintenance Worksheet to "match" related invoices debit memos and credit memos.
|
| 22 |
DOCUMENT_LINE |
Number(6,0) |
INTEGER NOT NULL |
Specifies the line number of a Document ID used as a reference on a Receivables item.
|
| 23 |
DST_ID_AR |
Character(10) |
VARCHAR2(10) NOT NULL |
Specifies the general ledger ChartField combination that is affected when subsequent activity such as a payment occurs for the item.
Prompt Table:
TRN_DST_VW
|
| 24 |
DST_ID_VAT |
Character(10) |
VARCHAR2(10) NOT NULL |
VAT Distribution Code
Prompt Table:
TRN_DSTVAT_VW
|
| 25 |
BILL_OF_LADING |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies a bill of lading number associated with a Receivables item.
|
| 26 |
SUBCUST_QUAL1 |
Character(15) |
VARCHAR2(15) NOT NULL |
Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
Default Value: WS_ID_CUST.SUBCUST_QUAL1
|
| 27 |
SUBCUST_QUAL2 |
Character(15) |
VARCHAR2(15) NOT NULL |
Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
Default Value: WS_ID_CUST.SUBCUST_QUAL2
|
| 28 |
BAL_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code - Bal Amount
|
| 29 |
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
|
| 30 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 31 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
Default Value: 1
|
| 32 |
BAL_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Balance - Base Currency
|
| 33 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 34 |
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.
|
| 35 |
ITEM_ACCTG_DT |
Date(10) |
DATE |
Specifies the accounting date of the original item and appears on subsequent entries. This field is used in multicurrency processing.
|
| 36 |
ITEM_ENTRY_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Original Item Entry Type
|
| 37 |
ITEM_ENTRY_REASON |
Character(5) |
VARCHAR2(5) NOT NULL |
Original Item Entry Reason
|
| 38 |
AMT_REM |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount Remaining
|
| 39 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 40 |
DISC_DT |
Date(10) |
DATE |
Specifies the date before which payment must be made on an invoice in order to qualify for a discount. This field applies to the first of two possible discounts and is associated with the discount amount specified in DISC_AMT.
|
| 41 |
MATCH_SEQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Match Sequence
|
| 42 |
REAL_GAIN_LOSS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Represents the monetary amount of realized gain or loss calculated by the system during payment application or maintenance worksheet (Receivables).
|
| 43 |
RATE_MULT_ORIG |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Original Rate Multiplier
|
| 44 |
RATE_DIV_ORIG |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Original Rate Divisor
|
| 45 |
CURRENCY_CD_ORIG |
Character(3) |
VARCHAR2(3) NOT NULL |
Prior Currency Code
|
| 46 |
BAL_AMT_ORIG |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Balance - Last Revalued Amount
|
| 47 |
DST_ID_REAL |
Character(10) |
VARCHAR2(10) NOT NULL |
Specifies the general ledger ChartField combination for posting realized gain or loss calculated by the system during payment application or maintenance worksheet (Receivables).
Prompt Table:
TRN_DSTRL_VW
|
| 48 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 49 |
AMT_SEL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount selected
|
| 50 |
ITEM_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 51 |
ITEM_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Item Amount Base
|
| 52 |
ITEM_MTCH |
Character(33) |
VARCHAR2(33) NOT NULL |
Matched Item
|
| 53 |
ITEM_LINE_MTCH |
Number(6,0) |
INTEGER NOT NULL |
Matched Item Line
|
| 54 |
ORDER_NO |
Character(10) |
VARCHAR2(10) NOT NULL |
Identifies a customer order number that appears as a reference on a receivables pending item.
Date Initials Issue Description
022701 mv SP2 (F-CJORGENS-3) CSR Desktop
|
| 55 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
|
| 56 |
ITEM_ENTRY_USE |
Character(5) |
VARCHAR2(5) NOT NULL |
Item Entry Use ID
|
| 57 |
TO_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
To Business Unit
|
| 58 |
TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
To Customer ID
|
| 59 |
TO_SUBCUST_QUAL1 |
Character(15) |
VARCHAR2(15) NOT NULL |
To Subcustomer Qualifier 1
|
| 60 |
TO_SUBCUST_QUAL2 |
Character(15) |
VARCHAR2(15) NOT NULL |
To Subcustomer Qualifier 2
|
| 61 |
CR_ANALYST |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the personnel code for the person who works with a customer to establish credit limits and payment terms. This field is required for a bill-to customer.
Prompt Table:
TRN_ANALYST_VW
|
| 62 |
SALES_PERSON |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the personnel code for the person who works with a customer as a sales representative. This field is required for a customer that functions as a bill-to customer.
Prompt Table:
TRN_SALES_VW
|
| 63 |
COLLECTOR |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the personnel code for the person who works with a customer to collect overdue payments.
Prompt Table:
TRN_COLLECTR_VW
|
| 64 |
TO_COLLECTOR |
Character(8) |
VARCHAR2(8) NOT NULL |
Transfer To Collector
Prompt Table:
TRN_COLLECTR_VW
|
| 65 |
TO_SALES_PERSON |
Character(8) |
VARCHAR2(8) NOT NULL |
Transfer To Sales Person
Prompt Table:
TEAM_MEMBER_VW
Set Control Field: BUSINESS_UNIT
|
| 66 |
TO_CR_ANALYST |
Character(8) |
VARCHAR2(8) NOT NULL |
Transfer To Credit Analyst
Prompt Table:
TRN_ANALYST_VW
|
| 67 |
TO_DST_ID_AR |
Character(10) |
VARCHAR2(10) NOT NULL |
Transfer To Dist ID AR
Prompt Table:
%EDITTABLE
|
| 68 |
TO_ENTRY_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Transfer To Entry Type
Prompt Table:
TRN_ENTRY_VW
|
| 69 |
TO_ENTRY_REASON |
Character(5) |
VARCHAR2(5) NOT NULL |
Transfer To Entry Reason
Prompt Table:
TRN_REASON_VW
|
| 70 |
TO_ENTRY_EVENT |
Character(10) |
VARCHAR2(10) NOT NULL |
Entry Event
Prompt Table:
EE_AR_CODE1_VW
|
| 71 |
TO_GL_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
To GL Business Unit
|
| 72 |
TO_BROKER_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Broker ID
Prompt Table:
CUST_BRK_A1S_VW
|
| 73 |
TO_INV_PROD_FAM_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Family
Prompt Table:
INV_ITEM_FAM
|
| 74 |
TO_SHIP_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Ship To Customer
Prompt Table:
AR_SLDSHP_VW
|
| 75 |
TO_SOLD_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Sold To Customer
Prompt Table:
AR_SLDBLL_VW
|
| 76 |
TO_AR_SPECIALIST |
Character(8) |
VARCHAR2(8) NOT NULL |
Accounts Recievable Specialist - person responsible for an action on an item.
Prompt Table:
AR_SPECIALIST
|
| 77 |
FROM_GL_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
From GL Business Unit
|
| 78 |
INTERCO_XREF |
Character(1) |
VARCHAR2(1) NOT NULL |
Intercompany XREF Needed
Y/N Table Edit
Default Value: N
|
| 79 |
TO_SETID_ENTRY |
Character(5) |
VARCHAR2(5) NOT NULL |
To Setid Entry Type
|
| 80 |
FROM_SETID_ENTRY |
Character(5) |
VARCHAR2(5) NOT NULL |
From Setid Entry Type
|
| 81 |
DOUBTFUL |
Character(1) |
VARCHAR2(1) NOT NULL |
Identifies items ( or invoices ) which probably will not be paid by the customer. This status is used for items whose balances have been moved from the receivables account to the doubtful account using the transfer worksheet.
|
| 82 |
SALES_PERSON2 |
Character(8) |
VARCHAR2(8) NOT NULL |
Identifies a second Sales Person. Populated on the Item Table to identify an additional Sales Person the Item is applied to.
|
| 83 |
REGION_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
|
| 84 |
REVALUE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Can be either 'Y' or 'N'. This field is located on the ITEM Table and signifies whether or not an item will be considered by the Revaluation Process to be revaluated.
|
| 85 |
LC_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Treasury Letter of Credit Number Assigned by the System
|
| 86 |
AG_REF_NBR |
Number(16,0) |
DECIMAL(16) NOT NULL |
Payment Reference Number
|
| 87 |
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
|
| 88 |
CONTROL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the total monetary amount of all transactions within a group of pending items using the entry currency of each item. For mixed currencies this becomes a hash total. Receivables compares the control amount to the actual amount entered and calculates the difference in order to help verify that all entries have been made correctly.
|
| 89 |
CONTROL_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Identifies the control amount base.
|
| 90 |
DST_ID_TRAN_CTL |
Character(10) |
VARCHAR2(10) NOT NULL |
10 character value used to identify the transfer worksheet control distribution code.
|
| 91 |
CONTROL_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the currency for all Receivables items in a control group. If this field is not blank the system will accept items with the specified currency only.
|
| 92 |
CONTROL_CURR_BASE |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the base business unit or anchor business unit currency in a worksheet. This currency is used to calculate the control base amount of an item selected in a worksheet.
|
| 93 |
CONTROL_RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Used to calculate the control base amount for items selected in receivable worksheets
|
| 94 |
CONTROL_RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Used to calculate the control base amount for items selected on receivable worksheets.
|
| 95 |
CONTROL_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.
|
| 96 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
Default Value: 0
Prompt Table:
TRN_CUST_EF_VW
|
| 97 |
CLAIM_NO |
Character(30) |
VARCHAR2(30) NOT NULL |
Claim Number for an item
|
| 98 |
AR_SPECIALIST |
Character(8) |
VARCHAR2(8) NOT NULL |
Accounts Recievable Specialist - person responsible for an action on an item.
|
| 99 |
BROKER_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Broker ID
|
| 100 |
CARRIER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Carrier ID
|
| 101 |
CLAIM_DT |
Date(10) |
DATE |
Claim Date
|
| 102 |
CLASS_OF_TRADE |
Character(20) |
VARCHAR2(20) NOT NULL |
Class of Trade
|
| 103 |
DEDUCTION_STATUS |
Character(5) |
VARCHAR2(5) NOT NULL |
Deduction Status
C=Closed
I=In Process
O=Created/Opened
W=On Worksheet
|
| 104 |
DEDUCTION_DT |
Date(10) |
DATE |
Deduction Date
|
| 105 |
DIVISION |
Character(20) |
VARCHAR2(20) NOT NULL |
Division
|
| 106 |
DT_INVOICED |
Date(10) |
DATE |
Date Invoiced
|
| 107 |
INV_PROD_FAM_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Family
|
| 108 |
INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice
|
| 109 |
INVOICE_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Invoice Business Unit
|
| 110 |
MAJOR_CLASS |
Character(10) |
VARCHAR2(10) NOT NULL |
Major Classification
|
| 111 |
MEMO_STATUS_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Memo Status Code
|
| 112 |
MERCH_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Merchandising Type
|
| 113 |
PROOF_OF_DELIVERY |
Character(30) |
VARCHAR2(30) NOT NULL |
Proof of Delivery
|
| 114 |
SHIP_FROM_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Ship from INV BU
|
| 115 |
SHIP_TO_ADDR_NUM |
Number(5,0) |
INTEGER NOT NULL |
Ship To Address Sequence Num
|
| 116 |
SHIP_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Ship To Customer
|
| 117 |
SOLD_TO_ADDR_NUM |
Number(5,0) |
INTEGER NOT NULL |
Sold To Address Sequence Num
|
| 118 |
SOLD_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Sold To Customer
|
| 119 |
DISPUTE_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the reason that an item or customer is in dispute. For example the dispute status code might represent pricing error.
|
| 120 |
COLLECTION_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies a collection agency or the reason for placing a customer in collection. Collection status indicates that the customer is delinquent in making payments or the invoice is more than 120 days past due.
|
| 121 |
VAT_TREATMENT_GRP |
Character(4) |
VARCHAR2(4) NOT NULL |
VAT Treatment Group
|
| 122 |
PHYSICAL_NATURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods
S=Services
|
| 123 |
COUNTRY_LOC_BUYER |
Character(3) |
VARCHAR2(3) NOT NULL |
Buyer's Location Country - May be either the VAT Entity or the Trading Partner
|
| 124 |
STATE_LOC_BUYER |
Character(6) |
VARCHAR2(6) NOT NULL |
Buyer's Location State - May be either the VAT Entity or the Trading Partner
|
| 125 |
COUNTRY_LOC_SELLER |
Character(3) |
VARCHAR2(3) NOT NULL |
Seller's Location Country - May be either the VAT Entity or the Trading Partner
|
| 126 |
STATE_LOC_SELLER |
Character(6) |
VARCHAR2(6) NOT NULL |
Seller's Location State - May be either the VAT Entity or the Trading Partner
|
| 127 |
VAT_SVC_SUPPLY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Services Place of Supply Flag
1=Supplier's Countries
2=Buyer's Countries
3=Where Physically Performed
|
| 128 |
VAT_SERVICE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Service Type
1=Freight Transport
2=Other
3=Electronics/Communication
|
| 129 |
COUNTRY_VAT_PERFRM |
Character(3) |
VARCHAR2(3) NOT NULL |
Country Where Service Physically Performed
|
| 130 |
STATE_VAT_PERFRM |
Character(6) |
VARCHAR2(6) NOT NULL |
State Where Service Physically Performed
|
| 131 |
COUNTRY_VAT_SUPPLY |
Character(3) |
VARCHAR2(3) NOT NULL |
VAT Place of Supply Country
|
| 132 |
STATE_VAT_SUPPLY |
Character(6) |
VARCHAR2(6) NOT NULL |
VAT Place of Supply State
|
| 133 |
STATE_SHIP_FROM |
Character(6) |
VARCHAR2(6) NOT NULL |
Ship From State
|
| 134 |
STATE_SHIP_TO |
Character(6) |
VARCHAR2(6) NOT NULL |
Ship To State
|
| 135 |
VAT_RPT_CNTRY_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Reporting Country Source
1=Ship From
2=Ship To
3=VAT Entity
4=Service Performed Country
5=Supplier Location Country
6=Buyer Location Country
7=Buyer VAT Registration Country
|
| 136 |
STATE_VAT_DEFAULT |
Character(6) |
VARCHAR2(6) NOT NULL |
VAT Defaulting State
|
| 137 |
CONVERS_EXISTS |
Character(1) |
VARCHAR2(1) NOT NULL |
"A flag that indicates whether a conversation is associated with a single item or with multiple items ."
|
| 138 |
DTTM_REFRESHED |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last refresh of the expected results data. This field is used in the Batch Test Framework process.
|
| 139 |
INVOICE_DT |
Date(10) |
DATE |
Invoice Date
|
| 140 |
BUSINESS_UNIT_CA |
Character(5) |
VARCHAR2(5) NOT NULL |
Contracts Business Unit
|
| 141 |
CONTRACT_LINE_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Contract Line Num
|
| 142 |
SUBROG_CASE_NUM |
Character(30) |
VARCHAR2(30) NOT NULL |
Subrogation case number used for Insurance
|