BUSINESS_UNITBOE_TYPE1=Home Consumption
2=Warehousing
3=Ex-Bond
BILL_OF_ENTRYBOE_LINE_NBRSEQ_NBRA=Amount
P=Percentage
Q=Quantity
Prompt Table: PO_LC_COMP_VW1
BOE_LN_DUTY(SQL Table) |
Index Back |
|---|---|
Bill of Entry Line Duty |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | BOE_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Bill Of Entry Type
1=Home Consumption 2=Warehousing 3=Ex-Bond |
| 3 | BILL_OF_ENTRY |
Character(10) | VARCHAR2(10) NOT NULL | Bill of Entry ID |
| 4 | BOE_LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Bill of Entry Line Number |
| 5 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 6 | CSD_BASIS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Basis Amount for Customs duty and Sales Tax |
| 7 | CSD_BASIS_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Basis Amount for Customs Duty and Sales Tax in Base Currency |
| 8 | CSD_BASIS_AMT_RPT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Basis Amount for Customs Duty and Sales Tax in Reporting Currency |
| 9 | CSD_NRCVRY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Custom Duty NonRecovery Amount |
| 10 | CSD_NRCVRY_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Custom Duty NonRecovery Amount |
| 11 | CSD_NRCVRY_AMT_RPT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Custom Duty NonRecovery Amount |
| 12 | CSD_RCVRY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Custom Duty Recovery Amount |
| 13 | CSD_RCVRY_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Custom Duty Recovery Amount |
| 14 | CSD_RCVRY_AMT_RPT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Custom Duty Recovery Amount |
| 15 | CSD_RCVRY_TAX_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Recovery Tax Percentage |
| 16 | CSD_TAX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Custom Duty Tax Amount |
| 17 | CSD_TAX_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Custom Duty Amount Base |
| 18 | CSD_TAX_AMT_RPT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Custom Duty Amount Reporting |
| 19 | CSD_TAX_RATE_PCT | Number(8,4) | DECIMAL(7,4) NOT NULL | Tax Rate Percentage |
| 20 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 21 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL | Business Unit Base Currency |
| 22 | CURRENCY_CD_RPT | Character(3) | VARCHAR2(3) NOT NULL | Currency Code - Reporting |
| 23 | DST_ACCT_TYPE | Character(4) | VARCHAR2(4) NOT NULL | 07/20/04 st: added RCN for Advance Reconciliation 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 |
| 24 | EXS_CALC_SCHEME | Character(1) | VARCHAR2(1) NOT NULL |
Calculation Scheme
A=Amount P=Percentage Q=Quantity |
| 25 | EXS_RCVRY_PCT | Number(8,4) | DECIMAL(7,4) NOT NULL | Tax Percentage |
| 26 | EXS_TAX_CMPNT_CD | Character(10) | VARCHAR2(10) NOT NULL | Tax Component Code |
| 27 | EXS_TAX_DEP_CD | Character(10) | VARCHAR2(10) NOT NULL | Tax Dependency Code |
| 28 | EXS_TAX_RATE_CD | Character(10) | VARCHAR2(10) NOT NULL | Tax Rate Code |
| 29 | EXS_TAX_RATE_PCT | Number(8,4) | DECIMAL(7,4) NOT NULL | Tax Rate Percentage |
| 30 | FLAT_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 31 | MISC_CHARGE_CODE | Character(10) | VARCHAR2(10) NOT NULL |
10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
Prompt Table: PO_LC_COMP_VW1 |
| 32 | MISC_CHARGE_SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 33 | 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. |
| 34 | UNIT_PRICE | Signed Number(17,5) | DECIMAL(15,5) NOT NULL | Unit Price |