SETIDUA_DST_ACCT_TYPEFRG=Freight Expense
MISC=Miscellaneous Charge Expense
NRV=Non Recoverable VAT
STX=Sales Tax Expense
UTX=Use Tax Expense
DEFAULT_FLAGUPG_CHARGE_CODEUA_CODE_DTL(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | UA_DST_ACCT_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement
11/11/99 llr: Added ADVP for Payables Advance Payment
FRG=Freight Expense MISC=Miscellaneous Charge Expense NRV=Non Recoverable VAT STX=Sales Tax Expense UTX=Use Tax Expense |
| 3 | DEFAULT_FLAG |
Character(1) | VARCHAR2(1) NOT NULL | Default |
| 4 | UPG_CHARGE_CODE |
Character(10) | VARCHAR2(10) NOT NULL | VARCHAR2(10) NOT NULL |