|
|
|
|
|
|
|
|
|
| Previous | Next | Contents | Index | Navigation | Glossary | Library |
| Column Name | Specify Value? | Available ID Conversion | Default Parameter(s) |
|---|---|---|---|
| ATTRIBUTE1 to ATTRIBUTE15 | |||
| ATTRIBUTE_CATEGORY | |||
| BATCH_DATE | |||
| BATCH_ID | No | ||
| BATCH_SOURCE_ID | NO PARAMETER | ||
| COMMENTS | |||
| CONTROL_AMOUNT | |||
| CONTROL_COUNT | |||
| CREATED_BY | No | ||
| CREATION_DATE | No | ||
| CURRENCY_CODE | Entity: CURRENCY Parameter: CURRENCY_ NAME | NO PARAMETER | |
| EXCHANGE_DATE | |||
| EXCHANGE_RATE | EXCHANGE_DATE, TRX_DATE, EXCHANGE_RATE_TYPE, CURRENCY_CODE | ||
| EXCHANGE _RATE_TYPE | |||
| GL_DATE | TRX_DATE | ||
| LAST_UPDATED_BY | No | ||
| LAST_UPDATE_DATE | No | ||
| LAST_UPDATE_LOGIN | No | ||
| NAME | |||
| ORG_ID | No | ||
| PROGRAM_ APPLICATION_ID | No | ||
| PROGRAM_ID | No | ||
| PROGRAM_UPDATE _DATE | No | ||
| PURGED_CHILDREN _FLAG | |||
| REQUEST_ID | No | ||
| SET_OF_BOOKS_ID | No | ||
| STATUS | BATCH_STATUS | NO PARAMETER | |
| TYPE | No | Entity: TYPE Parameter: CUST_TRX_ TYPE_NAME | |
| Table 1 - 28. (Table 2 of 2) | |||
| Column Name | Specify Value? | Available ID Conversion | Default Parameter(s) |
|---|---|---|---|
| AGREEMENT_ID | Entity: AGREEMENT Parameter: AGREEMENT _NAME | INITIAL_CUSTOMER _TRX_ID | |
| ATTRIBUTE1 to ATTRIBUTE15 | |||
| ATTRIBUTE_CATEGORY | |||
| BATCH_ID | Entity: BATCH Parameter: BATCH_NAME | ||
| BATCH_SOURCE_ID | Entity: BATCH_SOURCE Parameter: BATCH_ SOURCE_ NAME | BATCH_ID | |
| BILL_TO_CONTACT_ID | Entity: CONTACT Parameters: CUSTOMER_ID, FIRST_NAME, LAST_NAME | ||
| BILL_TO_CUSTOMER_ID | If you know the customer name... Entity: CUSTOMER_NAME Parameter: CUSTOMER_ NAME | ||
| If you know the customer number... Entity: CUSTOMER_NUM Parameter: CUSTOMER_ NUMBER | |||
| BILL_TO_SITE_USE_ID | Entity: SITE_USE Parameters: CUSTOMER_ID, SITE_USE_CODE, ADDRESS1-4, CITY, STATE, PROVINCE, POSTAL_CODE, COUNTY, COUNTRY | BILL_TO_CUSTOMER_ID, PREVIOUS_CUSTOMER_ TRX_ID | |
| COMMENTS | |||
| COMPLETE_FLAG | No | ||
| CREATED_BY | No | ||
| CREATED_FROM | No | ||
| CREATION_DATE | No | ||
| CREDIT_METHOD_FOR_ INSTALLMENTS | Entity: CREDIT_METHOD_ FOR_INSTALLMENTS Parameter: CR_METHOD_ FOR_ INSTALLMENT_ NAME | ||
| CREDIT_METHOD_FOR_ RULES | Entity: CREDIT_METHOD_ FOR _RULES Parameter: CREDIT_ METHOD_FOR _RULES_ NAME | ||
| CUSTOMER_BANK_ ACCOUNT_ID | If you know the bank account name... Entity: BANK_ACCOUNT_ NAME Parameters: BANK_ ACCOUNT_NAME, BANK_BRANCH_ID | TRX_DATE, CURRENCY _CODE, PAYING_CUSTOMER_ID, PAYING_SITE_USE_ID, BILL_TO_CUSTOMER_ID, BILL_TO_SITE_USE_ID | |
| If you know the bank account number... Entity: BANK_ACCOUNT_ NUM Parameter: BANK_ ACCOUNT_NUM, BANK_BRANCH_ID | |||
| If you know the bank branch name... Entity: BANK_BRANCH Parameters: BANK_NAME, BANK_BRANCH_NAME | |||
| CUSTOMER_REFERENCE | |||
| CUSTOMER_REFERENCE_DATE | |||
| CUSTOMER_TRX_ID | No | ||
| CUST_TRX_TYPE_ID | INITIAL_CUSTOMER _TRX_ID, BATCH_ID, BATCH_SOURCE_ID, TRX_DATE, CLASS, INVOICING_RULE_ID, TRX_DATE, BATCH_ID | ||
| DEFAULT_TAX_EXEMPT_FLAG | CLASS | ||
| DEFAULT_USSGL_ TRANSACTION_CODE | |||
| DEFAULT_USSGL_TRX_ CODE_CONTEXT | |||
| DOC_SEQUENCE_ID | Entity: DOC_SEQUENCE Parameter: DOC_ SEQUENCE_NAME | ||
| DOC_SEQUENCE_VALUE | |||
| EDI_PROCESSED_FLAG | |||
| EDI_PROCESSED_STATUS | |||
| END_DATE_ COMMITMENT | |||
| EXCHANGE_DATE | |||
| EXCHANGE_RATE | BATCH_EXCHANGE_ RATE, EXCHANGE_DATE, TRX_DATE, EXCHANGE_TYPE, CURRENCY_CODE | ||
| EXCHANGE_RATE_TYPE | Entity: EXCHANGE_RATE_ TYPE Parameter: USER_ CONVERSION_TYPE | ||
| FINANCE_CHARGES | |||
| FOB_POINT | Entity: FOB Parameter: FOB_POINT_ NAME | ||
| GLOBAL_ATTRIBUTE1 to GLOBAL_ATTRIBUTE20 | |||
| GLOBAL_ATTRIBUTE_ CATEGORY | |||
| INITIAL_CUSTOMER_TRX_ID | |||
| INTERFACE_HEADER_ ATTRIBUTE1 to INTERFACE_HEADER_ ATTRIBUTE15 | |||
| INTERFACE_HEADER_ CONTEXT | |||
| INTERNAL_NOTES | |||
| INVOICE_CURRENCY_ CODE | NO PARAMETER | ||
| INVOICING_RULE_ID | Entity: INVOICING_RULE Parameter: UOM_NAME | ||
| LAST_PRINTED_ SEQUENCE_NUM | No | ||
| LAST_UPDATED_BY | No | ||
| LAST_UPDATE_DATE | No | ||
| LAST_UPDATE_LOGIN | No | ||
| ORG_ID | No | ||
| ORIG_SYSTEM_BATCH_ NAME | |||
| PAYING_CUSTOMER_ID | If you know the customer name... Entity: CUSTOMER_NAME Parameter: CUSTOMER_ NAME | BILL_TO_CUSTOMER_ID | |
| If you know the customer number... Entity: CUSTOMER_NUM Parameter: CUSTOMER_ NUMBER | |||
| PAYING_SITE_USE_ID | Entity: SITE_USE Parameters: CUSTOMER_ID, SITE_USE_CODE, ADDRESS1-4, CITY, STATE, PROVINCE, POSTAL_CODE, COUNTY, COUNTRY | BILL_TO_SITE_USE_ID | |
| POSTING_CONTROL_ID | No | ||
| POST_REQUEST_ID | No | ||
| PREVIOUS_CUSTOMER_ TRX_ID | |||
| PRIMARY_SALESREP_ID | If you know the salesperson name... Entity: SALESREP_NAME Parameter: SALESREP_ NAME | PREVIOUS_CUSTOMER_ TRX_ID, TRX_DATE, BILL_TO_CUSTOMER_ID | |
| If you know the salesperson number... Entity: SALESREP_NUMBER Parameter: SALESREP_ NUMBER | |||
| PRINTING_COUNT | No | ||
| PRINTING_LAST_ PRINTED | No | ||
| PRINTING_OPTION | BATCH_SOURCE_ID, CUST_TRX_TYPE_ID | ||
| PRINTING_ORIGINAL_ DATE | No | ||
| PRINTING_PENDING | |||
| PROGRAM_ APPLICATION_ID | No | ||
| PROGRAM_ID | No | ||
| PROGRAM_UPDATE_ DATE | No | ||
| PURCHASE_ORDER | |||
| PURCHASE_ORDER_ DATE | |||
| PURCHASE_ORDER_ REVISION | |||
| RA_POST_LOOP_ NUMBER | No | ||
| REASON_CODE | If you know the credit memo reason... Entity: CM_REASON Parameter: CM_REASON_ NAME | ||
| If you know the invoice reason... Entity: INVOICE_REASON Parameter: INVOICE_ REASON_NAME | |||
| RECEIPT_METHOD_ID | Entity: RECEIPT_METHOD Parameter: RECEIPT_ METHOD_NAME | TRX_DATE, CURRENCY_CODE, PAYING_CUSTOMER_ID, PAYING_SITE_USE_ID, BILL_TO_CUSTOMER_ID, BILL_TO_SITE_USE_ID | |
| RECURRED_FROM_TRX_NUMBER | |||
| RELATED_BATCH_ SOURCE_ID | |||
| REMIT_TO_ADDRESS_ID | BILL_TO_SITE_USE_ID | ||
| REQUEST_ID | No | ||
| SET_OF_BOOKS_ID | No | ||
| SHIPMENT_ID | |||
| SHIP_DATE_ACTUAL | |||
| SHIP_TO_CONTACT_ID | Entity: CONTACT Parameters: CUSTOMER_ID, FIRST_NAME, LAST_NAME | ||
| SHIP_TO_CUSTOMER_ID | If you know the customer name... Entity: CUSTOMER_NAME Parameter: CUSTOMER_ NAME | ||
| If you know the customer number... Entity: CUSTOMER_NUM Parameter: CUSTOMER_ NUMBER | |||
| SHIP_TO_SITE_USE_ID | Entity: SITE_USE Parameters: CUSTOMER_ID, SITE_USE_CODE, ADDRESS1-4, CITY, STATE, PROVINCE, POSTAL_CODE, COUNTY, COUNTRY | SHIP_TO_CUSTOMER_ID, PREVIOUS_CUSTOMER _TRX _ID | |
| SHIP_VIA | Entity: SHIP_VIA Parameter: SHIP_VIA_NAME | ||
| SOLD_TO_CONTACT_ID | Entity: CONTACT Parameters: CUSTOMER_ID, FIRST_NAME, LAST_NAME | ||
| SOLD_TO_CUSTOMER_ID | If you know the customer name... Entity: CUSTOMER_NAME Parameter: CUSTOMER_ NAME | BILL_TO_CUSTOMER_ID | |
| If you know the customer number... Entity: CUSTOMER_NUM Parameter: CUSTOMER_ NUMBER | |||
| SOLD_TO_SITE_USE_ID | Entity: SITE_USE Parameters: CUSTOMER_ID, SITE_USE_CODE, ADDRESS1-4, CITY, STATE, PROVINCE, POSTAL_CODE, COUNTY, COUNTRY | BILL_TO_SITE_USE_ID | |
| START_DATE_ COMMITMENT | |||
| STATUS_TRX | Entity: STATUS_TRX Parameter: STATUS_TRX_ NAME | BATCH_SOURCE_ID, CUST_TRX_TYPE_ID | |
| TERM_DUE_DATE | |||
| TERM_ID | Entity: TERM Parameter: TERM_NAME | BATCH_SOURCE_ID, CUST_TRX_TYPE_ID | |
| TERRITORY_ID | Entity: TERRITORY_ID Parameters: TERR_ SEGMENT1-TERR_ SEGMENT20 | ||
| TRX_NUMBER | |||
| WAYBILL_NUMBER | |||
| WH_UPDATE_DATE | |||
| Table 1 - 29. (Table 7 of 7) | |||
| Column Name | Specify Value? | Available ID Conversion | Default Parameter(s) |
|---|---|---|---|
| ACCOUNTING_RULE_ DURATION | ACCOUNTING_RULE_ID | ||
| ACCOUNTING_RULE_ID | Entity: ACCOUNTING_ RULE Parameter: ACCOUNTING_ RULE_NAME | INVENTORY_ITEM_ID, MEMO_LINE_ID | |
| ATTRIBUTE1 to ATTRIBUTE15 | |||
| ATTRIBUTE_CATEGORY | |||
| AUTORULE_COMPLETE_FLAG | No | ||
| AUTORULE_DURATION_PROCESSED | No | ||
| AUTOTAX | No | ||
| CREATED_BY | No | ||
| CREATION_DATE | No | ||
| CUSTOMER_TRX_ID | No | ||
| CUSTOMER_TRX_LINE_ID | No | ||
| DEFAULT_USSGL_ TRANSACTION_CODE | |||
| DEFAULT_USSGL_TRX_ CODE_CONTEXT | |||
| DESCRIPTION | INVENTORY_ITEM_ID, MEMO_LINE_ID | ||
| EXTENDED_AMOUNT | |||
| GLOBAL_ATTRIBUTE1 - GLOBAL_ATTRIBUTE20 | |||
| GLOBAL_ATTRIBUTE _CATEGORY | |||
| INITIAL_CUSTOMER_TRX_LINE_ID | |||
| INTERFACE_LINE_ ATTRIBUTE1 - INTERFACE_LINE_ ATTRIBUTE15 | |||
| INTERFACE_LINE_ CONTEXT | |||
| INVENTORY_ITEM_ID | Entity: INVENTORY_ITEM _ ID Parameters: ITEM_SEGMENT1 - ITEM_SEGMENT30 | ||
| ITEM_CONTEXT | |||
| ITEM_EXCEPTION_RATE_ID | PREVIOUS_CUSTOMER_ TRX_ LINE_ID | ||
| LAST_PERIOD_TO_ CREDIT | |||
| LAST_UPDATED_BY | No | ||
| LAST_UPDATE_DATE | No | ||
| LAST_UPDATE_LOGIN | No | ||
| LINE_NUMBER | |||
| LINE_TYPE | |||
| LINK_TO_CUST_TRX_ LINE_ID | No | ||
| LOCATION_SEGMENT_ID | PREVIOUS_CUSTOMER_ TRX _LINE_ID | ||
| MEMO_LINE_ID | Entity: MEMO_LINE Parameter: MEMO_LINE_ NAME | ||
| MOVEMENT_ID | No | ||
| ORG_ID | No | ||
| PREVIOUS_CUSTOMER_ TRX_ID | |||
| PREVIOUS_CUSTOMER_ TRX_LINE_ID | |||
| PROGRAM_ APPLICATION_ID | No | ||
| PROGRAM_ID | No | ||
| PROGRAM_UPDATE_ DATE | No | ||
| QUANTITY_CREDITED | |||
| QUANTITY_INVOICED | |||
| QUANTITY_ORDERED | |||
| REASON_CODE | |||
| REQUEST_ID | No | ||
| REVENUE_AMOUNT | |||
| RULE_START_DATE | ACCOUNTING_RULE_ID, INVOICING_RULE_ID, TRX_DATE | ||
| SALES_ORDER | |||
| SALES_ORDER_DATE | |||
| SALES_ORDER_LINE | |||
| SALES_ORDER_REVISION | |||
| SALES_ORDER_SOURCE | |||
| SALES_TAX_ID | PREVIOUS_CUSTOMER_ TRX_ LINE_ID | ||
| SET_OF_BOOKS_ID | No | ||
| TAXABLE_FLAG | |||
| TAX_EXEMPTION_ID | PREVIOUS_CUSTOMER_ TRX_ LINE_ID | ||
| TAX_EXEMPT_FLAG | CLASS | ||
| TAX_EXEMPT_NUMBER | |||
| TAX_EXEMPT_REASON_ CODE | Entity: TAX_REASON Parameter: TAX_EXEMPT_ REASON_CODE _NAME | ||
| TAX_PRECEDENCE | |||
| TAX_RATE | PREVIOUS_CUSTOMER_ TRX_ LINE_ID | ||
| TAX_VENDOR_RETURN_CODE | |||
| UNIT_SELLING_PRICE | CLASS, LINE_TYPE, MEMO_LINE_ID, EXCHANGE_RATE | ||
| UNIT_STANDARD_PRICE | CLASS, LINE_TYPE, MEMO_LINE_ID, EXCHANGE_RATE | ||
| UOM_CODE | Entity: UOM Parameter: UNIT_OF_ MEASURE | INVENTORY_ITEM_ID, MEMO_LINE_ID | |
| VAT_TAX_ID | Entity: TAX_CODE Parameters: TAX_CODE, TRX_DATE | PREVIOUS_CUSTOMER_ TRX _LINE_ID | |
| WH_UPDATE_DATE | |||
| Table 1 - 31. (Table 3 of 3) | |||
| Column Name | Specify Value? | Available ID Conversion | Default |
|---|---|---|---|
| ACCOUNT_CLASS | |||
| ACCOUNT_SET_FLAG | |||
| ACCTD_AMOUNT | |||
| AMOUNT | |||
| ATTRIBUTE1 to ATTRIBUTE15 | |||
| ATTRIBUTE_CATEGORY | |||
| CODE_COMBINATION_ID | Entity: CODE_ COMBINATION_ID Parameters: SEGMENT1 - SEGMENT30 | ||
| COMMENTS | |||
| CONCATENATED_ SEGMENTS | No | ||
| CREATED_BY | No | ||
| CREATION_DATE | No | ||
| CUSTOMER_TRX_ID | No | ||
| CUSTOMER_TRX_LINE_ID | No | ||
| CUST_TRX_LINE_GL_DIST_ID | No | ||
| CUST_TRX_LINE_ SALESREP_ID | No | If you know the salesperson name... Entity: SALESREP_NAME Parameter: SALESREP_ NAME | |
| If you know the salesperson number... Entity: SALESREP_NUMBER Parameter: SALESREP_ NUMBER | |||
| GL_DATE | BATCH_GL_DATE, TRX_DATE, COMMITMENT_ GL_DATE, PREV_TRX_GL_DATE, INVOICING_RULE_ID | ||
| GL_POSTED_DATE | No | ||
| LAST_UPDATED_BY | No | ||
| LAST_UPDATE_DATE | No | ||
| LAST_UPDATE_LOGIN | No | ||
| LATEST_REC_FLAG | |||
| ORG_ID | No | ||
| ORIGINAL_GL_DATE | |||
| PERCENT | |||
| POSTING_CONTROL_ID | No | ||
| POST_REQUEST_ID | No | ||
| PROGRAM_ APPLICATION_ID | No | ||
| PROGRAM_ID | No | ||
| PROGRAM_UPDATE_ DATE | No | ||
| RA_POST_LOOP_ NUMBER | No | ||
| REQUEST_ID | No | ||
| SET_OF_BOOKS_ID | No | NO PARAMETER | |
| USSGL_TRANSACTION_ CODE | Entity: USSGL Parameter: USSGL_TRX_ CODE_NAME | ||
| USSGL_TRANSACTION_ CODE_CONTEXT | |||
| Table 1 - 32. (Table 2 of 2) | |||
| Column Name | Specify Value? | Available ID Conversion | Default Parameter(s) |
|---|---|---|---|
| ATTRIBUTE1 to ATTRIBUTE15 | |||
| ATTRIBUTE_CATEGORY | |||
| CREATED_BY | No | ||
| CREATION_DATE | No | ||
| CUSTOMER_TRX_ID | No | ||
| CUSTOMER_TRX_LINE_ID | No | ||
| CUST_TRX_LINE_ SALESREP_ID | No | If you know the salesperson name... Entity: SALESREP_NAME Parameter: SALESREP_ NAME | |
| If you know the salesperson number... Entity: SALESREP_NUMBER Parameter: SALESREP_ NUMBER | |||
| LAST_UPDATED_BY | No | ||
| LAST_UPDATE_DATE | No | ||
| LAST_UPDATE_LOGIN | No | ||
| NON_REVENUE_ AMOUNT_SPLIT | |||
| NON_REVENUE_ PERCENT_SPLIT | |||
| ORG_ID | No | ||
| ORIGINAL_LINE_ SALESREP_ID | No | If you know the salesperson name... Entity: SALESREP_NAME Parameter: SALESREP_ NAME | |
| If you know the salesperson number... Entity: SALESREP_NUMBER Parameter: SALESREP_ NUMBER | |||
| PREV_CUST_TRX_LINE_ SALESREP_ID | If you know the salesperson name... Entity: SALESREP_NAME Parameter: SALESREP_ NAME | ||
| If you know the salesperson number... Entity: SALESREP_NUMBER Parameter: SALESREP_ NUMBER | |||
| PROGRAM_ APPLICATION_ID | No | ||
| PROGRAM_ID | No | ||
| PROGRAM_UPDATE_ DATE | No | ||
| REQUEST_ID | No | ||
| REVENUE_AMOUNT_ SPLIT | |||
| REVENUE_PERCENT_ SPLIT | |||
| SALESREP_ID | If you know the salesperson name... Entity: SALESREP_NAME Parameter: SALESREP_ NAME | ||
| If you know the salesperson number... Entity: SALESREP_NUMBER Parameter: SALESREP_ NUMBER | |||
| WH_UPDATE_DATE | |||
| Table 1 - 33. (Table 3 of 3) | |||
| Previous | Next | Contents | Index | Navigation | Glossary | Library |