EXT_SYSTEM_IDBUSINESS_UNITFAI_TRANSACTION_IDA=Anchor Flag Error
C=Closed - Not Reloadable
D=Different Dates error
E=Error
N=New - Not Processed
S=External Source Error
U=Unbalanced Entries
V=Valid
C=Closed
N=Unposted
P=Posted
FAI_TRANS_VW(SQL View) |
Index Back |
|---|
| SELECT A.EXT_SYSTEM_ID , A.BUSINESS_UNIT , A.FAI_TRANSACTION_ID , A.ACCOUNTING_DT , A.LEDGER_GROUP , A.EDIT_HDR_STATUS , A.POST_STATUS_FAI FROM PS_FAI_ACCTG_HDR A WHERE A.IN_PROCESS_FLG = 'N' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EXT_SYSTEM_ID |
Character(10) | VARCHAR2(10) NOT NULL | External System ID |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | FAI_TRANSACTION_ID |
Character(10) | VARCHAR2(10) NOT NULL | FAI Transaction ID |
| 4 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 5 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 6 | EDIT_HDR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Header Edit Status
A=Anchor Flag Error C=Closed - Not Reloadable D=Different Dates error E=Error N=New - Not Processed S=External Source Error U=Unbalanced Entries V=Valid |
| 7 | POST_STATUS_FAI | Character(1) | VARCHAR2(1) NOT NULL |
FAI Post Status
C=Closed N=Unposted P=Posted |