PROCESS_INSTANCED=Decrease
I=Increase
I=Item
P=Product
N=Not Posted
X=Don't Post
Y=Posted
EXD_INV_ADJ_AET(SQL Table) |
Index Back |
|---|---|
Invoice Adjustment StateRecord |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | EXD_ADJUST_NO | Character(10) | VARCHAR2(10) NOT NULL | Adjustment Excise Invoice Nbr |
| 3 | EXD_ADJUST_DT | Date(10) | DATE | Adjustment Date |
| 4 | EXD_ADJUST_LINE | Number(3,0) | SMALLINT NOT NULL | |
| 5 | EXD_ADJ_INC_DEC | Character(4) | VARCHAR2(4) NOT NULL |
Inc/Dec
D=Decrease I=Increase |
| 6 | EXD_ITEM_PROD | Character(18) | VARCHAR2(18) NOT NULL | Item |
| 7 | EXS_TAX_CMPNT_CD | Character(10) | VARCHAR2(10) NOT NULL | Tax Component Code |
| 8 | EXD_ITEM_PROD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Item/Prod Flag
I=Item P=Product |
| 9 | EXS_TAX_AMT_RPT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Sales Tax Amount Reporting Currency |
| 10 | EXS_TAX_RATE_AMT | Number(27,3) | DECIMAL(26,3) NOT NULL | Tax Rate Amount |
| 11 | EXS_TAX_RATE_PCT | Number(8,4) | DECIMAL(7,4) NOT NULL | Tax Rate Percentage |
| 12 | EXD_DUTY_CREDIT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Opening Balance |
| 13 | EXD_DUTY_DEBIT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Opening Balance |
| 14 | REASON_CD | Character(10) | VARCHAR2(10) NOT NULL | Reason Code |
| 15 | EXD_CHADOC_REF | Character(30) | VARCHAR2(30) NOT NULL | Challan Document |
| 16 | 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 |
| 17 | IN_PROCESS_FLG | Character(1) | VARCHAR2(1) NOT NULL | In process flag |
| 18 | POSTING_DATE | Date(10) | DATE | Posting Date |