PSARCH_IDPSARCH_BATCHNUMAE_HEADER_IDANCHOR_BUAE_LINE_NUMLEDGERC=Completed
E=Error
P=In Process
FAH_ACCTG_LN_H(SQL Table) |
Index Back |
|---|---|
FAH Acctg Line - Archive |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PSARCH_ID |
Character(8) | VARCHAR2(8) NOT NULL | Archive ID (see PSARCHTEMPLATE). |
| 2 | PSARCH_BATCHNUM |
Number(30,0) | DECIMAL(30) NOT NULL | Archive Batch Number |
| 3 | AE_HEADER_ID |
Number(18,0) | DECIMAL(18) NOT NULL | AE Header ID |
| 4 | ANCHOR_BU |
Character(5) | VARCHAR2(5) NOT NULL | 5 character value used to identify the anchor business unit. |
| 5 | AE_LINE_NUM |
Number(18,0) | DECIMAL(18) NOT NULL | AE Line Number |
| 6 | LEDGER |
Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 7 | FAI_TRANSACTION_ID | Character(10) | VARCHAR2(10) NOT NULL | FAI Transaction ID |
| 8 | FAI_LINE_NBR | Number(9,0) | DECIMAL(9) NOT NULL | FAI Line Number |
| 9 | GL_SL_LINK_ID | Number(18,0) | DECIMAL(18) NOT NULL | eBusiness Suite Sub-Ledger Accounting Link ID |
| 10 | SEGMENT2 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT2 |
| 11 | IU_ANCHOR_FLG | Character(1) | VARCHAR2(1) NOT NULL | Y/N flag used to specify which transaction line is the Inter/IntraUnit anchor flag (the line that contains the anchor Business Unit and ChartFields). |
| 12 | 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. |
| 13 | 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. " |
| 14 | FOREIGN_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item. |
| 15 | FOREIGN_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Foreign Currency Code |
| 16 | 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. |
| 17 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 18 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 19 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 20 | BUSINESS_UNIT_CHRG | Character(5) | VARCHAR2(5) NOT NULL | Charged Business Unit |
| 21 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 22 | SEGMENT3 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT3 |
| 23 | SEGMENT4 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT4 |
| 24 | SEGMENT5 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT5 |
| 25 | SEGMENT6 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT6 |
| 26 | SEGMENT7 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT7 |
| 27 | SEGMENT8 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT8 |
| 28 | SEGMENT9 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT9 |
| 29 | SEGMENT10 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT10 |
| 30 | SEGMENT11 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT11 |
| 31 | SEGMENT12 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT12 |
| 32 | SEGMENT13 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT13 |
| 33 | SEGMENT14 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT14 |
| 34 | SEGMENT15 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT15 |
| 35 | SEGMENT16 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT16 |
| 36 | SEGMENT17 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT17 |
| 37 | SEGMENT18 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT18 |
| 38 | SEGMENT19 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT19 |
| 39 | SEGMENT20 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT20 |
| 40 | SEGMENT21 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT21 |
| 41 | SEGMENT22 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT22 |
| 42 | SEGMENT23 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT23 |
| 43 | SEGMENT24 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT24 |
| 44 | SEGMENT25 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT25 |
| 45 | SEGMENT26 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT26 |
| 46 | SEGMENT27 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT27 |
| 47 | SEGMENT28 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT28 |
| 48 | SEGMENT29 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT29 |
| 49 | SEGMENT30 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT30 |
| 50 | TRANSFER_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Transfer Status
C=Completed E=Error P=In Process |
| 51 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 52 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 53 | LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |