NPST_DOC_STATUS(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_GL_NONVW |
| 3 | BAX_TRANSFER_ID | Character(12) | VARCHAR2(12) NOT NULL |
An unique key identifier that represents a bank transfer transaction.
Prompt Table: BAX_HEADER_TR |
| 4 | TRANSFER_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Transfer Type
00=Internal Transfer 01=External Transfer |
| 5 | TR_SOURCE_ID | Character(12) | VARCHAR2(12) NOT NULL |
An internal work field that represents a unique identifier for records depicting a given treasury po
Prompt Table: TR_WR_HEADER |
| 6 | TR_SOURCE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Note: Changes to Translate Values must also be made to TRA_SOURCE_CD and SOURCE_TYPE. These 3 fields must be kept in sync.
Values that are inactive are for use in TR Accounting only
B=BSP D=Deals E=Deal Fees F=Facility Fees H=Hedges I=Interest M=Deal: Estimated Maturity Accr N=Netted Deal O=Other P=Investment Pools R=EFT Fees S=Securities T=LC Fees W=EFT Requests X=Bank Transfers |
| 7 | BNK_ID_NBR | Character(20) | VARCHAR2(20) NOT NULL |
A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
Prompt Table: BANK_ID_VW |
| 8 | BANK_ACCOUNT_NUM | Character(35) | VARCHAR2(35) NOT NULL |
The literal unique identifier associated with a given bank/counterparty account.
Prompt Table: BANK_ACCTNUM_VW |
| 9 | TRAN_REF_ID | Character(20) | VARCHAR2(20) NOT NULL | Represents the unique transaction identifier in bank reconciliation processing. |
| 10 | RECEIVER_ID | Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 11 | RECV_LN_NBR | Number(5,0) | INTEGER NOT NULL | Receipt Line |
| 12 | RECV_SHIP_SEQ_NBR | Number(3,0) | SMALLINT NOT NULL | Receiver Shipping Sequence |
| 13 | DISTRIB_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Line |
| 14 | PO_RECEIPT_FLG | Character(1) | VARCHAR2(1) NOT NULL | PO Receipt Flag - identifies if the receipt is related to a purchase order |
| 15 | SHIP_DATE | Date(10) | DATE | Item Shipping Date |
| 16 | SHIP_FROM_LOC | Character(10) | VARCHAR2(10) NOT NULL | Ship From Location |
| 17 | SHIPMENT_NO | Character(30) | VARCHAR2(30) NOT NULL | Shipment Number |
| 18 | SHIPTO_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship To Location |
| 19 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 20 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 21 | RECV_DS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Distribution Status
C=Closed H=Hold M=Moved O=Open R=Received X=Cancelled |
| 22 | RECV_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Receipt Status
C=Closed Receipt H=Hold Receipt M=Moved to Destination N=PO Not Received O=Open P=PO Partially Received R=Fully Received X=Canceled |
| 23 | INVOICE | Character(22) | VARCHAR2(22) NOT NULL |
Invoice
Prompt Table: BI_HDR |
| 24 | INVOICE_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Invoice Type
ACR=Credit Bill ADJ=Adjustment Only bill ARB=Rebill Bill PRF=Pro Forma Invoice RAD=Regular bill with adjustments REG=Regular Bill |
| 25 | BI_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Billing Currency Code |
| 26 | INVOICE_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Invoice Amount |
| 27 | INVOICE_DT | Date(10) | DATE | Invoice Date |
| 28 | ADVANCE_ID | Character(10) | VARCHAR2(10) NOT NULL | Advance ID |
| 29 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 30 | CREATION_DT | Date(10) | DATE | Creation Date |
| 31 | APPROVAL_DT | Date(10) | DATE | Date of Approval |
| 32 | SHEET_ID | Character(10) | VARCHAR2(10) NOT NULL | Report ID |
| 33 | TREAS_HEADER_ID | Character(12) | VARCHAR2(12) NOT NULL |
The unique key identifier for a given deal transaction.
Prompt Table: TRX_HEADER_TR |
| 34 | TRANSACTION_DT | Date(10) | DATE | Transaction date (often used as trade date) |
| 35 | TRAN_DT | Date(10) | DATE | Represents the transaction date in bank reconciliation processing. |
| 36 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 37 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 38 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 39 | ACCTG_EVENT_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Accounting types for deal capture and hedging |
| 40 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 41 | SS_DOC | Character(10) | VARCHAR2(10) NOT NULL | Defines the source of a system source--- eg the source document. Used in the Gl subsystem Reconciliation process/inquiries. |
| 42 | TRN_BU | Character(5) | VARCHAR2(5) NOT NULL | Transfer Business Unit |
| 43 | TRN_ID | Character(15) | VARCHAR2(15) NOT NULL | Transfer Worksheet ID |
| 44 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 45 | PYMNT_ID | Character(10) | VARCHAR2(10) NOT NULL | Payment Number |
| 46 | DRAFT_BU | Character(5) | VARCHAR2(5) NOT NULL |
Identifies the Receivables business unit associated with a draft. This field is maintained by the Draft Creation process.
Prompt Table: SP_BUARDS_NONVW |
| 47 | DRAFT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Uniquely identifies a payment draft. The Draft ID is system-generated during the Draft Creation process or manually entered.
Prompt Table: DRAFT_CONTROL |
| 48 | PYMNT_CNT | Number(5,0) | INTEGER NOT NULL | Payments |
| 49 | DEPOSIT_BU | Character(5) | VARCHAR2(5) NOT NULL |
Identifies the business unit to which a deposit is posted.
Prompt Table: SP_BUARDE_NONVW |
| 50 | DEPOSIT_ID | Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated. |
| 51 | PAYMENT_SEQ_NUM | Number(6,0) | INTEGER NOT NULL | Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit. |
| 52 | GROUP_BU | Character(5) | VARCHAR2(5) NOT NULL |
Represents the high level grouping of multiple general ledger business units.
Prompt Table: SP_BUARGR_NONVW |
| 53 | GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL |
Uniquely identifies a collection of pending items that are to be posted to accounts receivable. The identifier is manually entered or automatically generated by the system.
Prompt Table: GROUP_CONTROL |
| 54 | 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.
Prompt Table:
CUST_SRCH_VW
|
| 55 | 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. |
| 56 | ITEM_LINE | Number(6,0) | INTEGER NOT NULL | Item Line |
| 57 | DD_BU | Character(5) | VARCHAR2(5) NOT NULL |
Specifies the business unit to which a direct debit is posted. This field is maintained by the Direct debit generation process.
Prompt Table: SP_BUARDS_NONVW |
| 58 | DD_ID | Character(15) | VARCHAR2(15) NOT NULL |
Specifies a sequence number assigned to a Direct Debit by the Direct Debit generation process.
Prompt Table: DD_CONTROL |
| 59 | WS_BU | Character(5) | VARCHAR2(5) NOT NULL | Worksheet Business Unit |
| 60 | WS_ID | Character(15) | VARCHAR2(15) NOT NULL | Worksheet ID |
| 61 | DRAFT_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Specifies the currency of a draft payment. The draft currency may or may not be the same as the base currency of the business unit handling the draft. |
| 62 | DRAFT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the amount of a draft payment. This field is maintained by the Draft Creation process. |
| 63 | DRAFT_APPROVAL | Character(1) | VARCHAR2(1) NOT NULL |
"Indicates whether or not a draft is pre-approved for payment by a bill-to customer. If the draft is pre-approved then it can be submitted to the customer's bank without the customer's sign-off. Otherwise the draft must be reviewed and approved by the customer before the enterprise can submit it to the bank for payment. This field is used only if the preferred payment method is ""Draft""."
P=Preapproved R=Approval Required |
| 64 | DD_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Specifies the currency in which a direct debit is created. This field is maintained by the Direct Debit generation process. |
| 65 | DD_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the amount of a direct debit in its entry currency (DD_CURRENCY). This field is maintained by the Direct debit generation process. |
| 66 | PMT_ID | Character(15) | VARCHAR2(15) NOT NULL | Payment id |
| 67 | ENTERED_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents the total currency amount of all pending items actually entered in a group and is compared with the control total amount. The Receivables Update program automatically calculates this total. |
| 68 | FORMAT_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL |
Specifies the currency that controls the precision of the amount totals for a group of pending items. If CONTROL_CURRENCY is entered then the same currency code should be used here.
Prompt Table: AR_CNTL_CUR_VW |
| 69 | ENTERED_CNT | Number(6,0) | INTEGER NOT NULL | Represents the number of pending items actually entered in a group and is compared with the control total count. The Receivables Update program automatically calculates this total. |
| 70 | DST_BAL_ITEM | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates whether or not the accounting entries for a receivables item are in balance. This field is maintained by the system.
I=Complete N=Not Applicable O=Incomplete |
| 71 | PAYMENT_ID | Character(15) | VARCHAR2(15) NOT NULL | Identifies a customer payment. This is usually a check number but may be some other identifying number. |
| 72 | PAYMENT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the amount of a customer payment. |
| 73 | PAYMENT_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL |
Identifies the currency of a customer payment. This is generally the same as the currency specified for the deposit but it can be different.
Prompt Table: AR_PAY_CUR_VW |
| 74 | ENTRY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents the monetary amount of a pending item transaction such as invoice or credit memo. |
| 75 | ENTRY_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Specifies the currency associated with the monetary amount of a pending item. |
| 76 | ENTRY_AMT_BASE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents the monetary amount of a pending item transaction such as invoice or credit memo in the base currency of the business unit. |
| 77 | 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. |
| 78 | PYMNT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Payment Amount |
| 79 | CURRENCY_PYMNT | Character(3) | VARCHAR2(3) NOT NULL |
Payment Currency
Prompt Table: CURR_PYMNT_VW |
| 80 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 81 | GROSS_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Gross Amount |
| 82 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 83 | 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. |
| 84 | 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. " |
| 85 | 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 |
| 86 | 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.
Y/N Table Edit |
| 87 | 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 |
| 88 | POST_STATUS_AP | Character(1) | VARCHAR2(1) NOT NULL |
Post Status
N=Payment Not Applied P=Posted U=Unposted |
| 89 | PAYMENT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Payment Status
A=Applied B=Bounced C=Complete E=Identified - Express I=Identified J=Directly Journalled R=Unposted Direct Journal U=Unidentified W=Worksheet |
| 90 | POSTED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a Receivables item has been posted. This field is automatically updated by the Receivables Update program.
N=Not Posted X=Don't Post Y=Posted |
| 91 | HOLD_SW | Character(1) | VARCHAR2(1) NOT NULL |
Hold Switch
N=No Hold Y=On Hold |
| 92 | DST_BAL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates whether or not the accounting entries for a group of pending items are balanced. This field is maintained by the Pending group Generator in PeopleSoft receivables.
I=Balanced O=Not Balanced |
| 93 | DRAFT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Draft Status
A=Accepted C=Complete D=Dishonored E=Void I=Identified L=Collateral M=Discounted N=No Action P=Pending R=Remitted T=Endorsed |
| 94 | DD_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates the stage of processing of a direct debit payment in receivables. This field is maintained by the Direct Debit generation process.
A=Accepted C=Complete E=Rejected N=No Action P=Pending R=Remitted Z=All |
| 95 | DRAFT_POST_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Draft Post Action
A=Actual D=Dishonor |
| 96 | PMT_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Payment status
C=Canceled CM=Cancelled with Message E=Error H=Flagged for Hold L=Awaiting Dispatch N=Not Processed P=Paid PC=Pending Cancellation PR=Pending Reversal R=Received by Bank RM=Reversed with Message S=Dispatched to Bank SC=In Process |
| 97 | POST_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a group of pending items is ready to be processed by the Receivable Update program. The "action" requested can be no action, priority scheduled or standard scheduled.
A=Do Not Post B=Balance Only Now D=Delete This Group Now E=Delete ALL Accounting Entries G=Generate GL Distribution I=Balance and Post Later L=Batch Standard N=Batch Priority V=View |
| 98 | EDIT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a group has been edited for valid values and control total balance. This field is populated automatically during online data entry and during the Receivables update process.
E=Edited N=Not Edited |
| 99 | POST_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a control group of pending items has been fully posted to customer accounts. The posting status also indicates whether or not there were errors encountered during posting. This field is automatically populated by the Receivables Update program.
%=All C=Complete E=Errors N=Not Posted |
| 100 | BAL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates whether or not the control totals for a deposit match the entered totals. A deposit is considered "balanced" when the two sets of totals are equal.
I=Balanced O=Not Balanced |
| 101 | BUDGET_HDR_STS_NP | Character(1) | VARCHAR2(1) NOT NULL |
Budget Ch'k Hdr Sts NonProrate
E=Error in Budget Check N=Not Budget Checked P=Provisionally Valid V=Valid Budget Check |
| 102 | DOC_TOL_HDR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Document Heade Document Tolerance Status
E=Error N=Not Checked R=Reset V=Valid |
| 103 | COMBO_ERROR_FLG | Character(1) | VARCHAR2(1) NOT NULL | Vouchers with Combo Errors |
| 104 | BUDGET_MISC_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Budget Checking Misc Status
E=Error in Budget Check N=Not Budget Checked P=Provisionally Valid V=Valid Budget Check |
| 105 | ENTRY_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
If translate values are added or changed, modify the following code to make sure the values appear accurately in the dropdown list in the search dialog: VCHR_SRCH_DEL.ENTRY_STATUS.SearchInit. Template Voucher status should not be visibile in the drop down.
C=Complete D=Through batch defaults E=Edited by Batch Voucher Module L=Reviewed through Maintenance M=Modified O=Open P=Postable R=Recycle S=Scheduled for Payment T=Template Voucher X=Deleted |
| 106 | PYMNT_SELCT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Payment Selection Status
C=Closed D=Negative Voucher Sum E=Externally Paid F=Federal Sanctions Error I=In Process - EFT N=Not Selected for Payment O=Financial Sanctions Review P=Paid R=Requested for Payment S=Settlement Payment V=Convert Error X=Canceled Y=Prepaid |
| 107 | PYMNT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Payment Status
A=Alignment E=ACH/EFT Prenote L=Stale Dated Payment N=Reprinted with same ref number O=Overflow P=Paid R=Replaced S=Stopped T=Undo Escheatment U=Undo Cancel V=Void W=Escheated Check X=Deleted |
| 108 | PYMNT_HOLD | Character(1) | VARCHAR2(1) NOT NULL |
Hold Payment
N=No Y=Yes |
| 109 | TR_APPV_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
An internal work field that indicates whether a given deal transaction has been approved by a reviewe
01=Authorized 02=Submitted 03=Pending Review 04=Deal Previewed 05=Deal Suspended 06=Deal Approved Default Value: 01 |
| 110 | APPROVAL_FLG_TR | Character(1) | VARCHAR2(1) NOT NULL |
An internal work field that indicates that a given treasury transaction has been approved by
A=Approved D=Denied N=None Required P=Pending Approval Default Value: N |
| 111 | TRA_PROCESS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
The processing status for a given accounting entry build.
A=Accruing D=Deactivated E=Error I=In Process N=Not Processed P=Processed T=Temporary Hold |
| 112 | ADV_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Advance Status
APY=Approved for Payment CLS=Closed DEN=Denied DNA=Denied by Approver DNU=Denied by Auditor HDA=On Hold, with Approver HDU=On Hold, with Auditor HLD=On Hold PAR=Approvals in Process PD=Paid PND=Pending PRO=In Process PST=Past Due Balance RAP=Approved RCN=Reconciled RRT=Reroute Transaction SFA=Submission in Process STG=Staged SUB=Submitted for Approval XML=Submitted, Pending Validation Default Value: PND |
| 113 | BILL_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Bill Status
CAN=Canceled FNL=Finalized Bill HLD=Hold Bill INV=Invoiced Bill NEW=New Bill PND=Pending Approval RDY=Ready to Invoice TMP=Temporary Bill TMR=Temporary Ready Bill Default Value: NEW |
| 114 | POST_STATUS_EX | Character(1) | VARCHAR2(1) NOT NULL |
Expenses Post Status
C=Closed M=Marked for Unpost N=Not Applied O=Unpost In Process P=Posted S=Close In Process U=Unposted Default Value: N |
| 115 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 116 | BOOK | Character(10) | VARCHAR2(10) NOT NULL | Asset Book Name |
| 117 | TRANS_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Types of Asset Management Transactions
ACR=Accretion Expense ADD=Asset Addition ADJ=Asset Cost Adjustment BKS=Book Adjustment BUD=Budgeted Depreciation DPR=Depreciation INF=Inflation Adjustment LEX=Lease Expense LPB=Budgeted Lease Payments LPY=Lease Payment PDP=Prior Period Depreciation PLP=Prior Lease Payment RAD=Manual Reserve Adjustment RCT=Asset Recategorization REI=Asset Reinstatement RES=Resume Depreciation RET=Asset Retirement RRC=Retro rate change for grp ast SUS=Suspend Depreciation TRF=Asset Transfer |
| 118 | TRANS_IN_OUT | Character(1) | VARCHAR2(1) NOT NULL |
Transaction In/Out
I=In M=IUT Proceeds Markup O=Out |
| 119 | CALC_DEPR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Depreciation Calc Status
C=Completed Depreciation H=Held For Transfer In I=In Processing N=Never Calculate Depreciation P=Pending Depreciation |
| 120 | CALC_DIST_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Acctg Entry Creation Status
C=Completed Distribution N=Never Calculate Distribution P=Pending Distribution R=Reconcilie Clearing |
| 121 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 122 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |