ÉÏÒ»Ò³  ÏÂÒ»Ò³          Ä¿Â¼  Ë÷Òý  ¶¨Î»  ´Ê»ã±í  ³ÌÐò¿â

¿Í»§½Ó¿Ú±í˵Ã÷ºÍÑéÖ¤

ÒÔÏÂÊÇÎå¸ö¿Í»§½Ó¿Ú±íµÄÏêϸÐÅÏ¢ÒÔ¼°ÔÚÔËÐпͻ§½Ó¿ÚʱӦÊÕ¿î¹ÜÀíϵͳ¶ÔÿÀ¸ËùÖ´ÐеÄÑéÖ¤ÐÅÏ¢¡£

RA_CUSTOMERS_INTERFACE

´Ë±í´æ´¢¿Í»§¡¢µØÖ·ºÍÒµÎñÄ¿µÄÐÅÏ¢¡£Èç¹ûÄú²»ÐèÒªµ¼Èë¿Í»§¡¢µØÖ·»òÒµÎñÄ¿µÄ£¬ÔòÎÞÐëÔڴ˱íÖÐÊäÈëÖµ¡£

À¸Ãû

Öµ

ADDRESS1 µ½ 4

Äú¿ÉÒÔÔÚ´ËËÄÀ¸ÖÐÊäÈë¿Í»§µÄµØÖ·£¬Ã¿¸öµØÖ·ÖÁ¶à¿ÉÒÔÊäÈëËÄÐС£

ÑéÖ¤£º Èç¹ûÄúÔÚ ORIG_SYSTEM_ADDRESS_REF ÖÐÊäÈëÖµ£¬Ôò±ØÐëÔÚ ADDRESS1 ÖÐÊäÈëÖµ¡£¶ÔÓÚ¾ßÓÐÏàͬµØÖ·²Î¿¼µÄ¶à¸öÐУ¬ÇëÔÚµØÖ· 1 µ½ 4 ÖвåÈëÖµ¡£
Ä¿µÄµØ£º RA_ADDRESSES.ADDRESS1¡¢RA_ADDRESSES.ADDRESS2¡¢RA_ADDRESSES.ADDRESS3¡¢RA_ADDRESSES.ADDRESS4

CITY STATE PROVINCE COUNTY POSTAL_CODE COUNTRY

Äú¿ÉÒÔÊäÈë´Ë¿Í»§µØÖ·µÄ³ÇÊС¢ÖÝ¡¢Ê¡¡¢ÏغÍÓÊÕþ±àÂë¡£Èç¹ûÄú½«¡°µØÖ·ÑéÖ¤¡±ÉèÖÃΪ¡°´íÎó¡±²¢ÇÒÒª¼ÆËãÏúÊÛË°£¬Ôò±ØÐëÊäÈëÒÑÔÚ AR_LOCATION_VALUES Öж¨ÒåµÄÖµ¡£Äú±ØÐë¶ÔÄÉË°µØµãµ¯ÐÔÓò½á¹¹Ëù»ùÓÚµÄÿ¸öµØÖ·ÒªËØÖ´Ðд˲½Öè¡£

Èç¹ûÄú½«¡°µØÖ·ÑéÖ¤¡±ÉèÖÃΪ¡°²»ÑéÖ¤¡±²¢ÇÒÔÚ AR_LOCATION_VALUES ÖÐÊäÈë²»´æÔÚµÄÖµ£¬Ôò¿Í»§½Ó¿Ú»á½«´ËÖµ²åÈë AR_LOCATION_VALUES¡£

Äú±ØÐëʼÖÕÊäÈë¹ú¼Ò/µØÇøÖµ¡£

ÑéÖ¤£º ÏرØÐë´æÔÚÓÚ FND_TERRITORIES ÖС£
Ä¿µÄµØ£º RA_ADDRESSES.CITY¡¢RA_ADDRESSES.STATE¡¢RA_ADDRESSES.PROVINCE¡¢RA_ADDRESSES.COUNTY RA_ADDRESSES.POSTAL_CODE¡¢RA_ADDRESSES.COUNTRY

ADDRESS_KEY

¿Í»§½Ó¿Úµ±Ç°²»Ê¹ÓôËÀ¸¡£

BILL_TO_ORIG_ ADDRESS_REF

ÊäÈëÄúÒªÓë´Ë¼Ç¼µÄ·¢ÔËÄ¿µÄµØµØÖ·Ïà¹ØÁªµÄ¿ªµ¥ÖÁµØµã¡£

ÑéÖ¤£º ½öÔڴ˼ǼÖÐµÄ SITE_USE_CODE À¸ÉèÖÃΪ¡°·¢ÔËÄ¿µÄµØ¡±Ê±²Å¿ÉÒÔÊäÈëÖµ¡£´ËÍ⣬´Ë¿Í»§»òÈκÎÏà¹Ø¿Í»§±ØÐë´æÔÚ¡°¿ªµ¥ÖÁ¡±µØÖ·¡£
Ä¿µÄµØ£º RA_SITE_USES.BILL_TO_SITE_USE_ID

CUSTOMER_ ATTRIBUTE_ CATEGORY

ÊäÈë˵Ã÷ÐÔµ¯ÐÔÓòÀà±ðÐÅÏ¢¡£ÕâЩÀ¸Îª¿ÉÑ¡À¸¡£

ADDRESS_ ATTRIBUTE_ CATEGORY

SITE_USE_ ATTRIBUTE_ CATEGORY

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º RA_CUSTOMERS.ATTRIBUTE_CATEGORY¡¢RA_ADDRESSES.ATTRIBUTE_CATEGORY¡¢RA_SITE_USES.ATTRIBUTE_CATEGORY

CUSTOMER_ ATTRIBUTE_1 µ½ 15

ÊäÈë˵Ã÷ÐÔµ¯ÐÔÓòÐÅÏ¢¡£ÕâЩÀ¸Îª¿ÉÑ¡À¸¡£

ADDRESS_ ATTRIBUTE_1 µ½ 15

SITE_USE_ ATTRIBUTE_1 µ½ 25

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º RA_CUSTOMERS.ATTRIBUTE1 µ½ 15¡¢RA_ADDRESSES.ATTRIBUTE1 µ½ 15¡¢ RA_SITE_USES.ATTRIBUTE1 µ½ 25

CUSTOMER_ CATEGORY_CODE

ÊäÈë¶Ô¿Í»§·ÖÀàµÄÀà±ð¡£Äú¿ÉÒÔʹÓÃÏÈÇ°ÔÚ¡°¿ìËÙ±àÂ롱´°¿ÚÖж¨ÒåµÄ¿Í»§Àà±ð¡£´ËÀ¸ÎªÒªÇóÀ¸¡£

ÑéÖ¤£º AR_LOOKUPS.LOOKUP_CODE£¬´Ë´¦ LOOKUP_TYPE = 'CUSTOMER_CATEGORY'
Ä¿µÄµØ£º RA_CUSTOMERS.CUSTOMER_CATEGORY_ CODE

CUSTOMER_ CLASS_CODE

ÊäÈë´Ë¿Í»§µÄ¿Í»§·ÖÀà¡£Äú¿ÉÒÔʹÓÃÏÈÇ°ÔÚ¡°¿ìËÙ±àÂ롱´°¿Ú¶¨ÒåµÄ¿Í»§·ÖÀà¡£´ËÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º AR_LOOKUPS.LOOKUP_CODE£¬´Ë´¦ LOOKUP_TYPE = 'CUSTOMER CLASS'
Ä¿µÄµØ£º RA_CUSTOMERS.CUSTOMER_CLASS

CUSTOMER_KEY

¿Í»§½Ó¿Úµ±Ç°²»Ê¹ÓôËÀ¸¡£

CUSTOMER_NAME

ÊäÈë¿Í»§Ãû³Æ¡£´ËÀ¸ÎªÒªÇóÀ¸¡£

ÑéÖ¤£º ÏàͬµÄ¿Í»§²Î¿¼Ôڴ˱íÖв»ÄܾßÓв»Í¬µÄ¿Í»§Ãû³Æ¡£
Ä¿µÄµØ£º RA_CUSTOMERS.CUSTOMER_NAME

CUSTOMER_ NUMBER

ÊäÈë´Ë¿Í»§µÄ±àºÅ¡£

ÑéÖ¤£º Èç¹ûÄúҪʹÓá°×Ô¶¯½øÐпͻ§±àÂ롱£¬Ôò´ËÀ¸±ØÐëΪ¿Õ¡£Èç¹ûÄú²»Ê¹Óá°×Ô¶¯½øÐпͻ§±àÂ롱£¬Ôò±ØÐëÊäÈë´ËÀ¸¡£RA_CUSTOMERS ÖеĴËÖµ±ØÐëÊÇΨһµÄ¡£
Ä¿µÄµØ£º RA_CUSTOMERS.CUSTOMER_NUMBER

CUSTOMER_STATUS

ÊäÈë´Ë¿Í»§µÄ״̬¡£´ËÀ¸ÎªÒªÇóÀ¸¡£

ÑéÖ¤£º ¡°ÓÐЧ¡±×´Ì¬Îª 'A'£¬¡°ÎÞЧ¡±×´Ì¬Îª 'I'¡£
Ä¿µÄµØ£º RA_CUSTOMERS.STATUS

CUSTOMER_TYPE

ÊäÈë¡°ÄÚ²¿¡±»ò¡°Íⲿ¡±ÒÔÖ¸Ã÷´Ë¿Í»§µÄ¿Í»§ÀàÐÍ¡£´ËÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º AR_LOOKUPS.LOOKUP_CODE£¬´Ë´¦ LOOKUP_TYPE = 'CUSTOMER_TYPE'£¬¾ßÓÐÏàͬ¿Í»§²Î¿¼µÄ¶à¸öÐбØÐë¾ßÓÐÏàͬµÄ¿Í»§ÀàÐÍ¡£

CUST_TAX_CODE SITE_USE_TAX_ CODE

È¡¾öÓÚËùÑ¡ÔñµÄÀ¸£¬ÊäÈëÄúÒªÖ¸¶¨ÖÁ´Ë¿Í»§»òÒµÎñÄ¿µÄµÄË°Âë¡£Äú±ØÐëʹÓÃÏÈÇ°ÔÚ¡°Ë°ÂëºÍË°ÂÊ¡±´°¿ÚÖж¨ÒåµÄË°Âë¡£ÕâЩÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º ±ØÐë´æÔÚÓÚ AR_VAT_TAX ÖС£
Ä¿µÄµØ£º RA_CUSTOMERS.TAX_CODE RA_SITE_USES.TAX_CODE

CUST_TAX_ EXEMPT_NUM

¿Í»§½Ó¿Úµ±Ç°²»Ê¹ÓôËÀ¸£¬±ØÐ뽫ÆäÁô¿Õ¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º ÎÞ

CUST_TAX_ REFERENCE

ÊäÈë´Ë¿Í»§µÄÄÉË°µÇ¼Ç±àºÅ¡£´ËÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º RA_CUSTOMERS.TAX_REFERENCE

CUST_SHIP_ VIA_CODE SITE_SHIP_ VIA_CODE

È¡¾öÓÚÑ¡ÔñµÄÀ¸£¬ÊäÈëÄúÒªÖ¸¶¨ÖÁ¿Í»§»òÒµÎñÄ¿µÄµÄ³ÐÔËÈË¡£Äú¿ÉÒÔʹÓÃÏÈÇ°ÔÚ¡°³ÐÔËÈË¡±´°¿ÚÖж¨ÒåµÄ³ÐÔËÈË¡£´ËÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º ±ØÐë´æÔÚÓÚ ORG_FREIGHT ÖС£
Ä¿µÄµØ£º RA_CUSTOMERS.SHIP_VIA¡¢RA_SITE_USES.SHIP_VIA

CREATED_BY

ÊäÈë´´½¨´ËÐеÄÓû§±êʶ¡£´ËÀ¸ÎªÒªÇóÀ¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º ÎÞ

CREATION_DATE

ÊäÈëϵͳÈÕÆÚ¡£´ËÀ¸ÎªÒªÇóÀ¸¡£

ÑéÖ¤£º ±ØÐëΪÓÐЧµÄÈÕÆÚ¸ñʽ¡£
Ä¿µÄµØ£º ÎÞ

DEMAND_ CLASS_CODE

ÊäÈë´ËµØÖ·µÄÐèÇó·ÖÀà¡£Äú¿ÉÒÔʹÓÃÏÈÇ°ÔÚ¡°ÐèÇó·ÖÀࡱ´°¿ÚÖж¨ÒåµÄÐèÇó·ÖÀà¡£´ËÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º ±ØÐë´æÔÚÓÚ FND_COMMON_LOOKUPS ÖÐ
Ä¿µÄµØ£º RA_SITE_USES.DEMAND_CLASS_CODE

INSERT_UPDATE_ FLAG

Ö¸¶¨ÊÇ·ñ²åÈëмǼ»ò¸üÐÂÏÖÓмǼ¡£´ËÀ¸ÎªÒªÇóÀ¸¡£

ÑéÖ¤£º 'I' ±íʾ²åÈ룬'U' ±íʾ¸üС£
Ä¿µÄµØ£º ÎÞ

INTERFACE_STATUS

´ËÀ¸ÓÉ¿Í»§½Ó¿ÚʹÓã¬Ó¦±£ÁôΪ¿Õ¡£¿Í»§½Ó¿Ú³ÌÐò½«ÒÔÓ¦ÓÃÓڴ˽ӿڼǼµÄËùÓдíÎóÐÅÏ¢À´¸üдËÀ¸¡£Èç¹û½Ó¿Ú¼Ç¼´æÔÚ¶à¸öÎÊÌ⣬Ôò¿Í»§½Ó¿Ú³ÌÐò½«ÒÔ¶à¸ö´íÎó´úÂëÀ´¸üÐÂÒýÀ¸¡£

LOCATION

ÊäÈë´ËÒµÎñÄ¿µÄµÄËÙ¼ÇÃû¡£ÔÚÊý¾ÝÊäÈë¹ý³ÌÖУ¬Äú¿ÉÒÔʹÓôËÖµ¿ìËÙ²éÕÒÒµÎñÄ¿µÄ¡£

ÑéÖ¤£º Èç¹û×Ô¶¯µØµã±àÂëÉèÖÃΪ¡°·ñ¡±£¬Äú±ØÐëÔÚ´ËÀ¸ÖÐÊäÈëÖµ¡£·ñÔòÎÞÐèÊäÈëÖµ¡£´ËÀ¸Öµ±ØÐëΪΨһֵ¡£
Ä¿µÄµØ£º RA_SITE_USES.LOCATION

×¢Ò⣺´ËÀ¸²»¿É¸üС£

LOCATION_CCID

´ËÀ¸ÓÉ¿Í»§½Ó¿ÚʹÓã¬Ó¦±£ÁôΪ¿Õ¡£¿Í»§½Ó¿Ú¿ÉÒÔÔÚ´ËÀ¸Öд洢ÓÐЧµØÖ·µÄ´úÂë×éºÏ±êʶ¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º ÎÞ

LAST_UPDATED_ BY

ÊäÈë¸üдËÐеÄÓû§±êʶ¡£´ËÀ¸ÎªÒªÇóÀ¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º ÎÞ

LAST_UPDATE_ DATE

ÊäÈëϵͳÈÕÆÚ¡£´ËÀ¸ÎªÒªÇóÀ¸¡£

ÑéÖ¤£º ±ØÐëΪÓÐЧµÄÈÕÆÚ¸ñʽ¡£
Ä¿µÄµØ£º ÎÞ

LAST_UPDATE_ LOGIN

ÊäÈë×¢²á±êʶ¡£´ËÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º ÎÞ

LANGUAGE

ÊäÈë´Ë¿Í»§µØµãËùʹÓõÄÓïÑÔ¡£´ËÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º ±ØÐë´æÔÚÓÚ FND_LANGUAGES.NLS_LANGUAGE ÖÐ
Ä¿µÄµØ£º RA_ADDRESSES.LANGUAGE

MESSAGE_ TEXT

´ËÀ¸ÓÉ¿Í»§½Ó¿ÚʹÓã¬Ó¦±£ÁôΪ¿Õ¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º ÎÞ

ORIG_SYSTEM_ ADDRESS_REF

ÊäÈëÒ»¸ö¿ÉÒÔÓÃÀ´Ö»Ê¶±ðԭʼϵͳÖд˵ØÖ·µÄÖµ¡£

´ËÀ¸ÊÇ RA_CUSTOMERS_INTERFACE Ö÷¹Ø¼ü×ÖµÄÒ»²¿·Ö¡£Ö÷¹Ø¼ü×ÖΪ ORIG_SYSTEM_CUSTOMER_REF¡¢ORIG_SYSTEM_ADDRESS_REF ºÍ SITE_USE_CODE µÄ×éºÏ¡£

ÒªÊäÈë¿Í»§µÄ¶à¸öµØÖ·£¬ÇëÊäÈë RA_CUSTOMERS_INTERFACE ÖоßÓÐÏàͬ¿Í»§ÐÅÏ¢µ«¾ßÓв»Í¬µØÖ·ÐÅÏ¢µÄ¶à¸ö¼Ç¼¡£

Èç¹ûÄúÒª²åÈë»ò¸üеØÖ·ÐÅÏ¢£¬Ôò±ØÐëÊäÈë´ËÀ¸¡£

ÑéÖ¤£º ¶ÔÓÚ²åÈ룬²»µÃ´æÔÚÓÚ RA_ADDRESSES ÖС£¶ÔÓÚ¸üУ¬±ØÐë´æÔÚÓÚ RA_ADDRESSES ÖС£
Ä¿µÄµØ£º RA_ADDRESSES.ORIG_SYSTEM_REFERENCE

ORIG_SYSTEM_ CUSTOMER_REF

ÊäÈëÒ»¸ö¿ÉÒÔÓÃÀ´Ö»Ê¶±ðԭʼϵͳÖд˿ͻ§µÄÖµ¡£

´ËÀ¸ÊÇ RA_CUSTOMERS_INTERFACE Ö÷¹Ø¼ü×ÖµÄÒ»²¿·Ö¡£Ö÷¹Ø¼ü×ÖΪ ORIG_SYSTEM_CUSTOMER_REF¡¢ORIG_SYSTEM_ADDRESS_REF ºÍ SITE_USE_CODE µÄ×éºÏ¡£

Èç¹ûÄúÒªÊäÈëпͻ§£¬Ôò»¹±ØÐëÔÚ RA_CUSTOMER_PROFILES_INTERFACE ÖÐÊäÈë¿Í»§²ãÅäÖÃÎļþ¡£´ËÀ¸ÎªÒªÇóÀ¸¡£

ÑéÖ¤£º ¶ÔÓÚ²åÈ룬²»µÃ´æÔÚÓÚ RA_CUSTOMERS ÖС£¶ÔÓÚ¸üУ¬±ØÐë´æÔÚÓÚ RA_CUSTOMERS ÖС£ÏàͬµÄ¿Í»§²Î¿¼Ôڴ˱íÖв»ÄܾßÓв»Í¬µÄ¿Í»§Ãû³Æ¡£´ËÀ¸µÄ²åÈëÖµ±ØÐëΪΨһֵ¡£
Ä¿µÄµØ£º RA_CUSTOMERS.ORIG_SYSTEM_REFERENCE

ORIG_SYSTEM_ PARENT_REF

ÊäÈëÏà¹Ø¿Í»§µÄԭʼϵͳ²Î¿¼£¨Èç¹û´æÔÚ£©¡£Èç¹ûÄúÔÚ´ËÀ¸ÖÐÊäÈëÖµ£¬ÏµÍ³½«¼ì²é RA_SYSTEM_PARAMETERS.CREATE_RECIPROCAL_FLAG ÒÔÈ·¶¨Ó¦ÓóÌÐòÊÇ·ñÓ¦×Ô¶¯´´½¨Ï໥¹Øϵ¡£Èç¹û RA_SYSTEM_PARAMETERS.CREATE_RECIPROCAL_FLAG ÉèÖÃΪ¡°ÊÇ¡±£¬Ôòϵͳ½«ÔÚ RA_CUSTOMER_RELATIONSHIPS Öд´½¨¸½¼ÓµÄÏà·´·Ö¼¡£´ËÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º ±ØÐë´æÔÚÓÚ RA_CUSTOMERS.ORIG_SYSTEM_REFERENCE ÖС£¾ßÓÐÏàͬ¿Í»§²Î¿¼µÄ¶à¸öÐбØÐë¾ßÓÐÏàͬµÄ ORIG_SYSTEM_PARENT_REF¡£
Ä¿µÄµØ£º ²åÈë RA_CUSTOMER_RELATIONSHIPS.CUSTOMER_ID£¬´Ó RA_CUSTOMERS ÖÐÑ¡Ôñ CUSTOMER_ID£¬´Ë´¦ ORIG_SYSTEM_ REFERENCE = RA_CUSTOMERS_INTERFACE.ORIG_SYSTEM_PARENT_REF¡£

PRIMARY_SITE_ USE_FLAG

ÊäÈë¡°ÊÇ¡±»ò ¡°·ñ¡±ÒÔÖ¸Ã÷ÕâÊÇ·ñΪÖ÷ÒªÒµÎñÄ¿µÄ¡£½öÔÚ INSERT_UPDATE_FLAG ÉèÖÃΪ¡°ÊÇ¡±£¬²¢ÇÒÔÚ ORIG_SYSTEM_ADDRESS_REF ÖÐÊäÈëÖµ¡£

ÑéÖ¤£º ÿ¸öÓÃ;£¨¿ªµ¥ÖÁ¡¢·¢ÔËÄ¿µÄµØµÈ£©±ØÐë½ö¾ßÓÐÒ»¸öÖ÷ÒªÒµÎñÄ¿µÄ¡£¿ÉÑ¡Öµ±ØÐëΪ¿Õ¡¢¡°ÊÇ¡±»ò¡°·ñ¡±¡£ÔÚ²åÈëµØַʱ±ØÐëÊäÈë´ËÀ¸£¬ÔڼǼÓÃÓÚ¸üÐÂÄ¿µÄʱ´ËÀ¸±ØÐëΪ¿Õ¡£´ËÀ¸²»¿É¸üС£
Ä¿µÄµØ£º RA_SITE_USES.PRIMARY_FLAG

REQUEST_ID

´ËÀ¸ÓÉ¿Í»§½Ó¿ÚʹÓã¬Ó¦±£ÁôΪ¿Õ¡£

SITE_USE_CODE

ÊäÈë´Ë¿Í»§µØÖ·µÄÒµÎñÄ¿µÄ¡£Äú¿ÉÒÔʹÓÃÏÈÇ°ÔÚ¡°Ó¦ÊÕ¿î¿ìËÙ±àÂ롱´°¿ÚÖÐÒÔ¡°¿Í»§µØÖ·ÒµÎñÄ¿µÄ¡±¿ìËÙ±àÂëÀàÐÍÀ´¶¨ÒåµÄÒµÎñÄ¿µÄ¡£

´ËÀ¸ÊÇ RA_CUSTOMERS_INTERFACE Ö÷¹Ø¼ü×ÖµÄÒ»²¿·Ö¡£Ö÷¹Ø¼ü×ÖΪ ORIG_SYSTEM_CUSTOMER_REF¡¢ORIG_SYSTEM_ADDRESS_REF ºÍ SITE_USE_CODE µÄ×éºÏ¡£

Èç¹ûÔÚ ORIG_SYSTEM_ ADDRESS_REF ÊäÈëÖµ£¬Ôò±ØÐëÔÚ´ËÀ¸ÊäÈëÖµ¡£ÒªÊäÈëµØÖ·µÄ¶à¸öÒµÎñÄ¿µÄ£¬ÇëÔÚ RA_CUSTOMERS_INTERFACE ÖÐÊäÈëÏàͬµÄ¿Í»§ºÍµØÖ·ÐÅÏ¢£¬µ«Ê¹Óõص㲻ͬµÄ¶à¸ö¼Ç¼¡£Äú½ö¿ÉÒÔ¶Ôÿ¸öµØÖ·Ö¸¶¨Ò»ÖÖÒµÎñÄ¿µÄ¡£

ÑéÖ¤£º µ± LOOKUP_TYPE = 'SITE_USE_CODE'ʱ£¬ÊäÈëµÄÖµ±ØÐëµÈÓÚ AR_LOOKUPS.LOOKUP_CODE ÖеÄÖµ¡£Èç¹ûÄúÒª¸üРPRIMARY_SITE_USE_FLAG¡¢LOCATION¡¢SITE_SHIP_VIA_CODE¡¢SITE_USE_TAX_CODE »ò SITE_USE_TAX_REFERENCE£¬Ôò´ËÀ¸±ØÐëΪ¿Õ¡£´ËÀ¸µÄ²åÈëÖµ±ØÐëΪΨһֵ¡£
Ä¿µÄµØ£º RA_SITE_USES.SITE_USE_CODE

SITE_USE_TAX_ EXEMPT_NUM

¿Í»§½Ó¿Úµ±Ç°²»Ê¹ÓôËÀ¸£¬±ØÐ뽫ÆäÁô¿Õ¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º ÎÞ

SITE_USE_TAX_ REFERENCE

ÊäÈë´ËµØµãµÄÄÉË°µÇ¼Ç±àºÅ¡£´ËÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º RA_SITE_USES.TAX_REFERENCE

VALIDATED_FLAG

´ËÀ¸ÓÉ¿Í»§½Ó¿ÚʹÓã¬Ó¦±£ÁôΪ¿Õ¡£

Ä¿µÄµØ£º RA_CUSTOMERS.CUSTOMER_TYPE

WARNING_TEXT

¿Í»§½Ó¿Úµ±Ç°²»Ê¹ÓôËÀ¸¡£

RA_CUSTOMER_PROFILES_INTERFACE

´Ë±í´æ´¢¿Í»§ÅäÖÃÎļþÐÅÏ¢¡£Èç¹ûÄúÔÚ RA_CUSTOMERS_INTERFACE ÖÐÊäÈëпͻ§£¬Ôò±ØÐëÊäÈëÒѾ­´æÔڵĿͻ§ÅäÖÃÎļþ·ÖÀà»ò¿Í»§ÅäÖÃÎļþÖµ¡£Èç¹ûÄú²»ÊäÈëпͻ§»ò¶Ô¿Í»§µØÖ·Ö¸¶¨¿Í»§ÅäÖÃÎļþÐÅÏ¢£¬ÔòÎÞÐëÔڴ˱íÖÐÊäÈëÖµ¡£

À¸Ãû

Öµ

ACCOUNT_STATUS

ÊäÈë´Ë¿Í»§ÕÊ»§µÄ״̬¡£Äú¿ÉÒÔʹÓÃÏÈÇ°ÔÚ¡°Ó¦ÊÕ¿î¿ìËÙ±àÂ롱´°¿ÚÖÐÒÔ¡°ÕÊ»§×´Ì¬¡±¿ìËÙ±àÂëÀàÐͶ¨ÒåµÄÕÊ»§×´Ì¬¡£´ËÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º AR_LOOKUPS.LOOKUP_CODE£¬´Ë´¦ LOOKUP_TYPE = 'ACCOUNT_STATUS'
Ä¿µÄµØ£º AR_CUSTOMER_PROFILES.ACCOUNT_STATUS

ATTRIBUTE_ CATEGORY AMOUNT_ ATTRIBUTE_ CATEGORY

ÊäÈë˵Ã÷ÐÔµ¯ÐÔÓòÀà±ðÐÅÏ¢¡£ÕâЩÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º AR_CUSTOMER_PROFILES.ATTRIBUTE_CATEGORY AR_CUSTOMER_PROFILE_AMOUNTS.ATTRIBUTE_CATEGORY

ATRIBUTE 1 µ½ 15 AMOUNT_ ATTRIBUTE 1 µ½ 15

ÊäÈë˵Ã÷ÐÔµ¯ÐÔÓòÐÅÏ¢¡£ÕâЩÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º AR_CUSTOMER_PROFILES.ATTRIBUTE1 µ½ 15 AR_CUSTOMER_PROFILE_AMOUNTS.ATTRIBUTE1 µ½ 15

AUTO_REC_INCL_ DISPUTED_FLAG

Ö¸¶¨ÊÇ·ñÔÚ´´½¨¿Í»§µÄ×Ô¶¯ÊÕ¿îʱÄÉÈë¾ßÓÐÕùÒéµÄ½èÏî¡£Èç¹ûûÓÐÕâÑùµÄ½èÏÔòĬÈÏֵΪ¡°·ñ¡±¡£

ÑéÖ¤£º ±ØÐëµÈÓÚ 'Y'£¨ÊÇ£©»ò 'N'£¨·ñ£©¡£ÔÚÅäÖÃÎļþ·ÖÀàΪ¿Õʱ±ØÐëÊäÈë´ËÀ¸¡£
Ä¿µÄµØ£º AR_CUSTOMER_PROFILES.AUTO_REC_ INCL_DISPUTED_FLAG

AUTOCASH_ HIERARCHY_NAME

ÊäÈëÖ¸¶¨ÖÁ´Ë¿Í»§µÄ×Ô¶¯ÊÕÏÖ¹æÔò¼¯¡£Äú¿ÉÒÔʹÓÃÏÈÇ°ÔÚ¡°×Ô¶¯ÊÕÏÖ¹æÔò¼¯¡±´°¿ÚÖж¨ÒåµÄ×Ô¶¯ÊÕÏÖ¹æÔò¼¯¡£

ÑéÖ¤£º ±ØÐë´æÔÚÓÚ AR_AUTOCASH_HIERARCHIES ÖС£ÔÚûÓÐÖ¸¶¨ÅäÖÃÎļþ·ÖÀàʱ±ØÐëÊäÈë´ËÀ¸¡£
Ä¿µÄµØ£º AR_CUSTOMER_PROFILES.AUTOCASH_HIERARCHY_ID

AUTO_REC_MIN_ RECEIPT_AMOUNT

ÔÚ´´½¨´Ë±ÒÖÖµÄ×Ô¶¯ÊÕ¿îʱÊäÈë¶Ô´Ë¿Í»§Ö¸¶¨µÄ×îСÊÕ¿î¶î¡£´ËÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º AR_CUSTOMER_PROFILE_AMOUNTS.AUTO_REC_MIN_RECEIPT_AMOUNT

CHARGE_ON_ FINANCE_ CHARGE_FLAG

Ö¸¶¨ÊÇ·ñ¶Ô¿Í»§¼ÆË㸴Àû¡£

ÑéÖ¤£º ±ØÐëµÈÓÚ 'Y'£¨ÊÇ£©»ò 'N'£¨·ñ£©¡£ÔÚ INTEREST_CHARGES ÉèÖÃΪ¡°ÊÇ¡±ÇÒûÓÐÖ¸¶¨ÅäÖÃÎļþ·ÖÀàʱҪÇóÊäÈë´ËÀ¸¡£Èç¹û INTEREST_CHARGES Ϊ¿Õ»òÉèÖÃΪ¡°·ñ¡±£¬ÇëÎðÊäÈëÖµ¡£
Ä¿µÄµØ£º AR_CUSTOMER_PROFILES.CHARGE_ON_ FINANCE_CHARGE_FLAG

CLEARING_DAYS

ÊäÈë´Ë¿Í»§ÅäÖÃÎļþµÄ½áËãÌìÊý¡£

ÑéÖ¤£º ±ØÐëΪ´óÓÚ»òµÈÓÚÁãµÄÕûÊý¡£
Ä¿µÄµØ£º AR_CUSTOMER_PROFILES.CLEARING_DAYS

COLLECTOR_NAME

ÊäÈëÖ¸¶¨ÖÁ´Ë¿Í»§ÅäÖÃÎļþµÄÊÕÕÊÔ±¡£

ÑéÖ¤£º ±ØÐëÊÇ AR_COLLECTORS ÖеÄΨһֵÇÒ STATUS = 'A'£¨ÓÐЧ£©¡£ÔÚûÓÐÖ¸¶¨ÅäÖÃÎļþ·ÖÀàʱ±ØÐëÊäÈë´ËÀ¸¡£
Ä¿µÄµØ£º AR_CUSTOMER_PROFILES.COLLECTOR_ID£¨´Ó CUSTOMER_NAME µ¼³ö£©

CREATED_BY

ÊäÈë´´½¨´ËÐеÄÓû§±êʶ¡£´ËÀ¸ÎªÒªÇóÀ¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º ÎÞ

CREATION_DATE

ÊäÈëϵͳÈÕÆÚ¡£´ËÀ¸ÎªÒªÇóÀ¸¡£

ÑéÖ¤£º ±ØÐëΪÓÐЧµÄÈÕÆÚ¸ñʽ¡£
Ä¿µÄµØ£º ÎÞ

CREDIT_BALANCE_ STATEMENTS

Ö¸¶¨ÊÇ·ñÏò¿Í»§·¢Ëͺ¬´ûÏîÓà¶îµÄ¶ÔÕʵ¥¡£

ÑéÖ¤£º ±ØÐëµÈÓÚ 'Y'£¨ÊÇ£©»ò 'N'£¨·ñ£©£¬ÇÒÔÚ STATEMENTS = 'N' ʱ±ØÐëÑ¡Ôñ 'N'¡£ÔÚûÓÐÖ¸¶¨ÅäÖÃÎļþ·ÖÀàʱ±ØÐëÊäÈë´ËÀ¸£»ÔÚ STATEMENTS =¡°ÊÇ¡±Ê±Ò²±ØÐëÊäÈë´ËÀ¸£»ÔÚ STATEMENTS Ϊ¿Õʱ´ËÀ¸±ØÐëΪ¿Õ¡£
Ä¿µÄµØ£º AR_CUSTOMER_PROFILES.CREDIT_BALANCE_STATEMENTS

CREDIT_HOLD

Ñ¡ÔñÊÇ·ñ½«¿Í»§´ûÏî¹ÒÆð¡£

ÑéÖ¤£º ±ØÐëµÈÓÚ 'Y'£¨ÊÇ£©»ò 'N'£¨·ñ£©¡£
Ä¿µÄµØ£º AR_CUSTOMER_PROFILES.CREDIT_HOLD

CREDIT_RATING

ÊäÈë´Ë¿Í»§µÄÐÅÓÃÆÀ¼¶¡£Äú¿ÉÒÔʹÓÃÏÈÇ°ÔÚ¡°Ó¦ÊÕ¿î¿ìËÙ±àÂ롱´°¿ÚÖÐÒÔ¡°¿Í»§ÐÅÓÃÆÀ¼¶¡±¿ìËÙ±àÂëÀàÐͶ¨ÒåµÄÐÅÓÃÆÀ¼¶¡£´ËÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º AR_LOOKUPS.LOOKUP_CODE£¬´Ë´¦ LOOKUP_TYPE = 'CREDIT_RATING'
Ä¿µÄµØ£º AR_CUSTOMER_PROFILES.CREDIT_RATING

CURRENCY_CODE

ÊäÈë±ÒÖÖ´úÂëÒÔ¶¨Òå´Ë¿Í»§µÄ¿Í»§ÅäÖÃÎļþ½ð¶î¡£Äú¿ÉÒÔʹÓÃÏÈÇ°ÔÚ¡°±ÒÖÖ¡±´°¿ÚÖж¨ÒåµÄ±ÒÖÖ´úÂë¡£²»¿¼ÂÇ INSERT_UPDATE_FLAG ÖеĴ洢ֵ£¬¿Í»§½Ó¿ÚʼÖÕ²åÈë²¢¸üÐÂÄúÔڴ˱íÖÐÊäÈëµÄ¿Í»§ÅäÖÃÎļþ½ð¶îÖµ¡£Èç¹ûÒÔÏÂÈκÎÒ»À¸ÖоßÓÐÖµ£¬ÔòÄú±ØÐëÔÚ´ËÀ¸ÖÐÊäÈëÖµ¡£

INTEREST_RATE

MIN_DUNNING_AMOUNT

MIN_DUNNING_INVOICE_AMOUNT

MIN_FC_BALANCE_AMOUNT

MIN_FC_INVOICE_AMOUNT

MIN_STATEMENT_AMOUNT

OVERALL_CREDIT_LIMIT

TRX_CREDIT_LIMIT

ÑéÖ¤£º ±ØÐë´æÔÚÓÚ FND_CURRENCIES ÖС£ÔÚÌîÈëÅäÖÃÎļþ½ð¶îֵʱ±ØÐëÊäÈë´ËÀ¸¡££¨ÅäÖÃÎļþ½ð¶îÀ¸ÔÚÉÏÃæÁгö¡££©
Ä¿µÄµØ£º AR_CUSTOMER_PROFILE_AMOUNTS.CURRENCY_CODE

CUSTOMER_PROFILE_CLASS_NAME

ÊäÈëÄúÒªÖ¸¶¨ÖÁ´Ë¿Í»§»ò¡°¿ªµ¥ÖÁ¡±µØÖ·µÄ¿Í»§ÅäÖÃÎļþ·ÖÀàÃû³Æ¡£

Èç¹ûÄúÔÚ´ËÀ¸ÖÐÊäÈëÖµ£¬Ôòϵͳ½«Ê¹ÓÃÓë´Ë¿Í»§ÅäÖÃÎļþ·ÖÀà¹ØÁªµÄÅäÖÃÎļþÖµ¡£µ«ÊÇ£¬Äú¿ÉÒÔͨ¹ýÔÚÏàÓ¦À¸ÖÐÊäÈëÐÂÖµÀ´¸ÄдÕâЩĬÈÏÖµ¡£´ËÀ¸Îª¿ÉÑ¡À¸¡£

Èç¹ûÄúûÔÚÔÚ´ËÀ¸ÖÐÊäÈëÖµ£¬Ôò±ØÐëÔÚÒÔÏÂÀ¸ÖÐÊäÈëÖµ£º

COLLECTOR_NAME

CREDIT_BALANCE_STATEMENTS

CREDIT_CHECKING

AUTO_REC_INCL_DISPUTED_FLAG

DISCOUNT_TERMS

DUNNING_LETTERS£¨Èç¹û¡°ÊÇ¡±£¬Ôò»¹±ØÐëÔÚ DUNNING_LETTER_SET_NAME ÖÐÊäÈëÖµ£©

INTEREST_CHARGES£¨Èç¹û¡°ÊÇ¡±£¬Ôò»¹±ØÐëÔÚ INTEREST_PERIOD_DAYS ºÍ CHARGE_ON_FINANCE_CHARGE_FLAG ÖÐÊäÈëÖµ¡££©

STATEMENTS£¨Èç¹û¡°ÊÇ¡±£¬Ôò»¹±ØÐëÔÚ STATEMENT_CYCLE_NAME ÖÐÊäÈëÖµ¡££©

TOLERANCE

TAX_PRINTING_OPTION

OVERRIDE_TERMS

GROUPING_RULE_NAME

ÑéÖ¤£º ±ØÐëµÈÓÚ AR_CUSTOMER_PROFILE_CLASSES¡£NAME ºÍ STATUS = 'A'£¨ÓÐЧ£©
Ä¿µÄµØ£º AR_CUSTOMER_PROFILES.CUSTOMER_PROFILE_CLASS_ID£¨´Ó CUSTOMER_PROFILE_CLASS_NAME µ¼³ö¡££©

DISCOUNT_TERMS CREDIT_CHECKING DUNNING_LETTERS INTEREST_CHARGES STATEMENTS

Ö¸¶¨ÊÇ·ñÔÊÐíÕÛ¿Û¡¢¼ì²é´ûÏî¡¢·¢Ëʹߺ¯¡¢·ÑÓÃÀûÏ¢ºÍ£¨»ò£©·¢ËͶÔÕʵ¥¡£

ÑéÖ¤£º ±ØÐëµÈÓÚ 'Y'£¨ÊÇ£©»ò 'N'£¨·ñ£©¡£ÔÚûÓÐÖ¸¶¨ÅäÖÃÎļþ·ÖÀàʱ±ØÐëÊäÈë´ËÀ¸£»
Ä¿µÄµØ£º AR_CUSTOMER_PROFILES.DISCOUNT_TERMS AR_CUSTOMER_PROFILES.CREDIT_CHECKING AR_CUSTOMER_PROFILES.DUNNING_LETTERS AR_CUSTOMER_PROFILES.INTEREST_CHARGES AR_CUSTOMER_PROFILES.STATEMENTS

DISCOUNT_ GRACE_DAYS

ÊäÈë´Ë¿Í»§ÈÔ¿ÉÒÔ»ñµÃÕÛ¿ÛµÄÕÛ¿ÛÈÕÆÚÖ®ºóµÄÌìÊý¡£

ÑéÖ¤£º ´ËÊý×Ö±ØÐëΪ·Ç¸ºÊý£¨±ØÐë >= 0£©¡£DISCOUNT_TERMS Ϊ¿Õ»ò¡°·ñ¡±Ê±´ËÀ¸±ØÐëΪ¿Õ¡£
Ä¿µÄµØ£º AR_CUSTOMER_PROFILES.DISCOUNT_ GRACE_DAYS

DUNNING_LETTER_ SET_NAME

ÊäÈëÓë´Ë¿Í»§¹ØÁªµÄ´ßº¯¼¯¡£Äú¿ÉÒÔʹÓÃÏÈÇ°ÔÚ¡°´ßº¯¼¯¡±´°¿ÚÖж¨ÒåµÄ´ßº¯¡£

ÑéÖ¤£º ±ØÐë´æÔÚÓÚ AR_DUNNING_LETTER_SETS ÖС£ÔÚ DUNNING_LETTERS ÉèÖÃΪ¡°ÊÇ¡±Ê±±ØÐëÊäÈë´ËÀ¸£»ÔÚ DUNNING_LETTERS ÉèÖÃΪ¡°·ñ¡±»ò¿Õʱ´ËÀ¸±ØÐëΪ¿Õ¡£
Ä¿µÄµØ£º AR_CUSTOMER_PROFILES.DUNNING_ LETTER_SET_ID£¨´ÓDUNNING_LETTER_SET_NAME µ¼³ö)

GROUPING_ RULE_NAME

ÊäÈëÖ¸¶¨ÖÁ´Ë¿Í»§µÄ·Ö×é¹æÔò¡£Äú¿ÉÒÔʹÓÃÏÈÇ°ÔÚ¡°·Ö×é¹æÔò¡±´°¿ÚÖж¨ÒåµÄ·Ö×é¹æÔò¡£

ÑéÖ¤£º ±ØÐë´æÔÚÓÚ RA_GROUPING_RULES ÖС£ÔÚûÓÐÖ¸¶¨ÅäÖÃÎļþ·ÖÀàʱ±ØÐëÊäÈë´ËÀ¸¡£
Ä¿µÄµØ£º AR_CUSTOMER_PROFILES.GROUPING_ RULE_ID£¨´Ó GROUPING_RULE_NAME µ¼³ö£©

INTERFACE_STATUS

´ËÀ¸ÓÉ¿Í»§½Ó¿ÚʹÓã¬Ó¦±£ÁôΪ¿Õ¡£¿Í»§½Ó¿Ú³ÌÐò½«ÒÔÓ¦ÓÃÓڴ˽ӿڼǼµÄËùÓдíÎóÐÅÏ¢À´¸üдËÀ¸¡£Èç¹û½Ó¿Ú¼Ç¼¾ßÓжà¸öÎÊÌ⣬Ôò¿Í»§½Ó¿Ú³ÌÐò½«ÒÔ¶à¸ö´íÎó´úÂ루ÉÔºó½«ÔÚ±¾½ÚΪÄú½éÉÜ£©¸üдËÀ¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º ÎÞ

INSERT_ UPDATE_FLAG

ÊäÈëÖµÒÔÖ¸Ã÷ÊÇ·ñ²åÈëмǼ»ò¸üÐÂÏÖÓмǼ¡£

²»¹ÜÄúÔÚ´ËÀ¸ÖÐÊäÈëµÄÖµ£¬Äú²»ÄܲåÈë»ò¸üÐÂÒÔÏÂÀ¸ÖеÄÅäÖÃÎļþÐÅÏ¢£ºCURRENCY_CODE¡¢AUTO_REC_MIN_RECEIPT_AMOUNT¡¢INTEREST_RATE¡¢ MAX_INTEREST_CHARGE¡¢MIN_DUNNING_AMOUNT¡¢MIN_DUNNING_INVOICE_AMOUNT¡¢ MIN_FC_BALANCE_AMOUNT¡¢MIN_FC_INVOICE_AMOUNT¡¢MIN_STA TEMENT_AMOUNT¡¢ OVERALL_CREDIT_LIMIT¡¢TRX_CREDIT_LIMIT¡¢AMOUNT_ATTRIBUTE_CATEGORY ºÍ AMOUNT_ATTRIBUTE1 µ½ AMOUNT_ATTRIBUTE15¡£

Èç¹ûÄú³¢ÊÔ²åÈëеÄÅäÖÃÎļþ½ð¶îÐÅÏ¢£¬Ôò¼´Ê¹ÔÚ´ËÀ¸ÉèÖÃΪ 'U' ʱ£¬¿Í»§½Ó¿ÚÈÔ½«×Ô¶¯²åÈë´ËÐÅÏ¢¡£ÀýÈ磬Èç¹ûÄúÒª¸üÐÂÒѲåÈë¼Ç¼µÄ¡°´òÓ¡Ë°¡±Ñ¡ÏîÖµ£¬²¢ÒªÍ¬Ê±ÊäÈë´Ë¿Í»§ÅäÖÃÎļþµÄбÒÖÖ´úÂ룬ÇëÔÚ´ËÀ¸ÖÐÊäÈë 'U'¡£¿Í»§½Ó¿Ú½«×Ô¶¯¸üдòÓ¡Ë°Ñ¡ÏîÖµ²¢×Ô¶¯²åÈëбÒÖÖ´úÂë¡£

´ËÀ¸ÎªÒªÇóÀ¸¡£

ÑéÖ¤£º 'I' ±íʾ²åÈ룬'U' ±íʾ¸üС£
Ä¿µÄµØ£º ÎÞ

INTEREST_ PERIOD_DAYS

ÊäÈëÀûÂÊËùÖ¸µÄÌìÊý¡£

ÑéÖ¤£º ´ËÊý×Ö±ØÐëΪÕý¡£ÔÚ INTEREST_CHARGES ÉèÖÃΪ¡°ÊÇ¡±Ê±±ØÐëÊäÈë´ËÀ¸£»ÔÚ DUNNING_LETTERS ÉèÖÃΪ¡°·ñ¡±»ò¿Õʱ´ËÀ¸±ØÐëΪ¿Õ¡£
Ä¿µÄµØ£º AR_CUSTOMER_PROFILES.INTEREST_ PERIOD_DAYS

INTEREST_RATE

ÊäÈëÏò´Ë¿Í»§ÊÕÈ¡µÄ´Ë±ÒÖÖÀûÂÊ¡£´ËÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º AR_CUSTOMER_PROFILE_AMOUNTS.INTEREST_RATE

LAST_UPDATED_ BY

ÊäÈë¸üдËÐеÄÓû§±êʶ¡£´ËÀ¸ÎªÒªÇóÀ¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º ÎÞ

LAST_UPDATE_ DATE

ÊäÈëϵͳÈÕÆÚ¡£´ËÀ¸ÎªÒªÇóÀ¸¡£

ÑéÖ¤£º ±ØÐëΪÓÐЧµÄÈÕÆÚ¸ñʽ¡£
Ä¿µÄµØ£º ÎÞ

LAST_UPDATE_ LOGIN

ÊäÈë×¢²á±êʶ¡£´ËÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º ÎÞ

MAX_INTEREST_ CHARGE

ÊäÈëÏò¸Ã¿Í»§ÊÕÈ¡µÄÿ¸ö·¢Æ±µÄ´Ë±ÒÖÖ×î´óÀûÏ¢¶î¡£´ËÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º AR_CUSTOMER_PROFILE_AMOUNTS.MAX_INTEREST_CHARGE

MIN_DUNNING_ AMOUNT

ÔÚÑ¡ÔñÒª´ß¿îµÄ¿Í»§Ö®Ç°£¬ÊäÈë¸Ã¿Í»§ÒѹýÆڵĴ˱ÒÖÖ×îС¶î¡£´ËÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º AR_CUSTOMER_PROFILE_AMOUNTS.MIN_DUNNING_AMOUNT

MIN_DUNNING_ INVOICE_AMOUNT

ÔÚÑ¡ÔñÒª´ß¿îµÄ¿Í»§Ö®Ç°£¬ÊäÈë¸Ã¿Í»§ÒѹýÆڵĴ˱ÒÖÖ×îС·¢Æ±¶î¡£´ËÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º AR_CUSTOMER_PROFILE_AMOUNTS.MIN_DUNNING_INVOICE_AMOUNT

MIN_FC_BALANCE_ AMOUNT

ÔÚÏò¸Ã¿Í»§ÊÕÈ¡¹ýÆÚÏîÄ¿µÄ´Ë±ÒÖÖ²ÆÎñ·ÑÓÃ֮ǰ£¬ÊäÈëÄúÒªÇóµÄ×îС¿Í»§Óà¶î¡£´ËÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º AR_CUSTOMER_PROFILE_AMOUNTS.MIN_FC_BALANCE_AMOUNT

MIN_FC_INVOICE_ AMOUNT

ÔÚÏò¸Ã¿Í»§ÊÕÈ¡¹ýÆÚÏîÄ¿µÄ´Ë±ÒÖÖ²ÆÎñ·ÑÓÃ֮ǰ£¬ÊäÈëÄúÒªÇóµÄ×îС·¢Æ±Óà¶î¡£´ËÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º AR_CUSTOMER_PROFILE_AMOUNTS.MIN_FC_INVOICE_AMOUNT

MIN_STATEMENT_ AMOUNT

ÊäÈë´Ë¿Í»§±ØÐ볬³öµÄ´Ë±ÒÖÖ×îСδ¸¶½ð¶î£¬ÒÔÈÃϵͳÉú³É¶ÔÕ˵¥¡£´ËÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º AR_CUSTOMER_PROFILE_AMOUNTS.MIN_STATEMENT_AMOUNT

ORIG_SYSTEM_ CUSTOMER_REF

ÊäÈëÄúÒª²åÈë»ò¸üпͻ§ÅäÖÃÎļþÐÅÏ¢µÄ±íʾ¿Í»§»ò¡°¿ªµ¥ÖÁ¡±µØµãµÄÖµ¡£

ÑéÖ¤£º ¶ÔÓÚ²åÈ룬´Ë¿Í»§²Î¿¼±ØÐë´æÔÚÓÚ RA_CUSTOMERS ÖлòÔÚ RA_CUSTOMERS_INTERFACE Öгɹ¦µØ½øÐÐÁËÑéÖ¤£»¶ÔÓÚ¸üУ¬´Ë¿Í»§²Î¿¼±ØÐë´æÔÚÓÚ RA_CUSTOMERS ÖС£
Ä¿µÄµØ£º AR_CUSTOMER_PROFILES.CUSTOMER_ID£¨´Ó ORIG_SYSTEM_CUSTOMER_REF µ¼³ö£©

ORIG_SYSTEM_ ADDRESS_REF

ÊäÈëÄúÒª²åÈë»ò¸üпͻ§ÅäÖÃÎļþÐÅÏ¢µÄ±íʾ¿Í»§¡°¿ªµ¥ÖÁ¡±µØÖ·µÄÖµ¡£ÓÐЧµÄ¡°¿ªµ¥ÖÁ¡±ÒµÎñÄ¿µÄ±ØÐëÓë´ËµØÖ·Ïà¹ØÁª¡£

ÑéÖ¤£º ¶ÔÓÚ²åÈ룬µØÖ·²Î¿¼±ØÐë´æÔÚÓÚ RA_ADDRESSES ÖлòÔÚ RA_CUSTOMERS_INTERFACE Öгɹ¦µØ½øÐÐÁËÑéÖ¤£»¶ÔÓÚ¸üУ¬´ËµØÖ·²Î¿¼±ØÐë´æÔÚÓÚ RA_ADDRESSES ÖС£
Ä¿µÄµØ£º AR_CUSTOMER_PROFILES.SITE_USE_ID£¨´Ó ORIG_SYSTEM_ADDRESS_REF µ¼³ö£©

OVERALL_ CREDIT_LIMIT

ÊäÈëÒªÌṩ¸ø¸Ã¿Í»§µÄ´Ë±ÒÖÖÐÅ´û×ܶ´ËÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º TRX_CREDIT_LIMIT ºÍ OVERALL_CREDIT_ LIMIT ±ØÐëÁ½Õß¾ùÌîÈë»òÁ½Õß¾ùΪ¿Õ¡£TRX_CREDIT_LIMIT ²»¿ÉÒÔ´óÓÚ OVERALL_CREDIT_LIMIT¡£

OVERRIDE_TERMS

Ö¸¶¨ÊÇ·ñ¿ÉÒÔÊäÈ븶¿îÌõ¼þ£¬´Ë¸¶¿îÌõ¼þÓë STANDARD_TERM_NAME ÖÐÊäÈëµÄ¸¶¿îÌõ¼þ²»Í¬¡£

ÑéÖ¤£º ±ØÐëµÈÓÚ 'Y'£¨ÊÇ£©»ò 'N'£¨·ñ£©¡£ÔÚûÓÐÖ¸¶¨ÅäÖÃÎļþ·ÖÀàʱ±ØÐëÊäÈë´ËÀ¸¡£
Ä¿µÄµØ£º AR_CUSTOMER_PROFILES.OVERRIDE_TERMS

PAYMENT_ GRACE_DAYS

ÔÚ¿ªÊ¼ÊÕÕʻ֮ǰ£¬ÊäÈëÔÊÐí´Ë¿Í»§ÊÕ¿îÓâÆÚµÄÌìÊý¡£

ÑéÖ¤£º ´ËÊý×Ö±ØÐëΪ·Ç¸ºÊý£¨±ØÐë >= 0£©¡£
Ä¿µÄµØ£º AR_CUSTOMER_PROFILES.PAYMENT_ GRACE_DAYS

PERCENT_ COLLECTABLE

ÊäÈëÄúÔ¤¼Æ¶¨ÆÚÊÕ¿îµÄ´Ë¿Í»§ÕÊ»§Óà¶î°Ù·Ö±È¡£´ËÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º ±ØÐë½éÓÚ 0 ºÍ 100 Ö®¼ä¡£
Ä¿µÄµØ£º AR_CUSTOMER_PROFILES.PERCENT_ COLLECTABLE

REQUEST_ID

´ËÀ¸ÓÉ¿Í»§½Ó¿ÚʹÓã¬Ó¦±£ÁôΪ¿Õ¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º ÎÞ

RISK_CODE

ÊäÈë´Ë¿Í»§µÄ·çÏÕ´úÂë¡£Äú¿ÉÒÔʹÓÃÏÈÇ°ÔÚ¡°¿ìËÙ±àÂ롱´°¿ÚÖÐÒÔ¡°¿Í»§ÐÅÓ÷çÏÕ¡±¿ìËÙ±àÂëÀàÐÍÀ´¶¨ÒåµÄ·çÏÕ´úÂë¡£´ËÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º AR_LOOKUPS.LOOKUP_CODE£¬´Ë´¦ LOOKUP_TYPE = 'RISK_CODE'
Ä¿µÄµØ£º AR_CUSTOMER_PROFILES.RISK_CODE

STANDARD_ TERM_NAME

ÊäÈë´Ë¿Í»§µÄ±ê×¼¸¶¿îÌõ¼þ¡£Äú¿ÉÒÔʹÓÃÏÈÇ°ÔÚ¡°¸¶¿îÌõ¼þ¡±´°¿ÚÖж¨ÒåµÄ¸¶¿îÌõ¼þ¡£´ËÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º ±ØÐë´æÔÚÓÚ RA_TERMS ÖУ»ÊäÈëµÄÖµ±ØÐëΪΨһֵ£»ÔÚûÓÐÖ¸¶¨ÅäÖÃÎļþ·ÖÀàʱ±ØÐëÊäÈë´ËÀ¸¡£
Ä¿µÄµØ£º AR_CUSTOMER_PROFILES.STANDARD_ TERMS¡££¨´Ó STANDARD_TERM_NAME µ¼³ö£©

STATEMENT_ CYCLE_NAME

ÊäÈëÓë´Ë¿Í»§¹ØÁªµÄ¶ÔÕʵ¥ÖÜÆÚ¡£Äú¿ÉÒÔʹÓÃÏÈÇ°ÔÚ¡°¶ÔÕʵ¥ÖÜÆÚ¡±´°¿ÚÖж¨ÒåµÄ¶ÔÕʵ¥ÖÜÆÚ¡£

ÑéÖ¤£º ±ØÐë´æÔÚÓÚ AR_STATEMENT_CYCLES ÖУ»ÔÚ STATEMENTS ÉèÖÃΪ¡°·ñ¡±»ò¿Õʱ´ËÀ¸±ØÐëΪ¿Õ£»ÔÚ STATEMENTS ÉèÖÃΪ¡°ÊÇ¡±Ê±±ØÐëÊäÈë´ËÀ¸£»ÊäÈëµÄÖµ±ØÐëΪΨһֵ¡£
Ä¿µÄµØ£º AR_CUSTOMER_PROFILES.STATEMENT_ CYCLE_ID£¨´Ó STATEMENT_CYCLE_NAME µ¼³ö£©

TAX_PRINTING_ OPTION

ÊäÈë´òÓ¡Ë°Ñ¡ÏîÒÔÖ¸Ã÷ÄúÒªÈçºÎ´òÓ¡´Ë¿Í»§·¢Æ±µÄ´òÓ¡Ë°ÐÅÏ¢¡£

ÑéÖ¤£º AR_LOOKUPS.LOOKUP_CODE£¬´Ë´¦ LOOKUP_TYPE = 'TAX_PRINTING_OPTION'¡£ÔÚûÓÐÖ¸¶¨ÅäÖÃÎļþ·ÖÀàʱ±ØÐëÊäÈë´ËÀ¸¡£
Ä¿µÄµØ£º AR_CUSTOMER_PROFILES.TAX_PRINTING_OPTION

TOLERANCE

ÔÚ²ÉÈ¡»î¶¯Ö®Ç°£¬ÊäÈë´Ë¿Í»§¿É³¬³öµÄÐÅÓÃÏÞ¶î°Ù·Ö±È¡£

ÑéÖ¤£º ±ØÐë½éÓÚ -100 ºÍ 100 Ö®¼ä¡£ÔÚûÓÐÖ¸¶¨ÅäÖÃÎļþ·ÖÀàʱ±ØÐëÊäÈë´ËÀ¸£»
Ä¿µÄµØ£º RA_CUSTOMER_PROFILES.TOLERANCE

TRX_CREDIT_ LIMIT

ÊäÈëÄúÒªÌṩ¸ø¸Ã¿Í»§µÄÿ¸ö¶©µ¥µÄ´Ë±ÒÖÖÐÅ´û¶î¡£

ÑéÖ¤£º TRX_CREDIT_LIMIT ºÍ OVERALL_CREDIT_ LIMIT ±ØÐëÁ½Õß¾ùÌîÈë»òÁ½Õß¾ùΪ¿Õ¡£TRX_CREDIT_LIMIT ²»¿ÉÒÔ´óÓÚ OVERALL_CREDIT_LIMIT¡£
Ä¿µÄµØ£º AR_CUSTOMER_PROFILE_AMOUNTS.TRX_CREDIT_LIMIT

VALIDATED_FLAG

´ËÀ¸ÓÉ¿Í»§½Ó¿ÚʹÓã¬Ó¦±£ÁôΪ¿Õ¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º ÎÞ
Ä¿µÄµØ£º AR_CUSTOMER_PROFILE_AMOUNTS.OVERALL_CREDIT_LIMIT

RA_CONTACT_PHONES_INTERFACE

´Ë±í´æ´¢ÁË¿Í»§¡¢µØÖ·ºÍÁªÏµÈ˵ĵ绰ºÅÂëÒÔ¼°¿Í»§ºÍµØÖ·µÄÁªÏµÈË¡£Èç¹ûÄú²»ÊäÈëµç»°»òÁªÏµÈËÐÅÏ¢£¬ÔòÎÞÐëÔڴ˱íÖÐÊäÈëÖµ¡£

À¸Ãû

Öµ

CONTACT_ ATTRIBUTE_ CATEGORY PHONE_ ATTRIBUTE_ CATEGORY

ÊäÈë˵Ã÷ÐÔµ¯ÐÔÓòÀà±ðÐÅÏ¢¡£ÕâЩÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º RA_CONTACTS.ATTRIBUTE_CATEGORY RA_PHONES.ATTRIBUTE_CATEGORY

CONTACT_ ATTRIBUTE 1 µ½ 25 PHONE_ ATTRIBUTE 1 µ½ 15

ÊäÈë˵Ã÷ÐÔµ¯ÐÔÓòÐÅÏ¢¡£ÕâЩÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º RA_CONTACTS.ATTRIBUTE1 µ½ 25

CONTACT_ FIRST_NAME

ÊäÈëÁªÏµÈ˵ÄÐÕÃû¡£´ËÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º RA_CONTACTS.FIRST_NAME

CONTACT_ JOB_TITLE

ÊäÈë´ËÁªÏµÈ˵Äְλ»òÔðÈΡ£Äú¿ÉÒÔʹÓÃÏÈÇ°ÔÚ¡°¿ìËÙ±àÂ롱´°¿ÚÖж¨ÒåµÄÁªÏµÈËְλ¡£´ËÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º AR_LOOKUPS.LOOKUP_CODE£¬´Ë´¦ LOOKUP_TYPE = 'JOB_TITLE'¡£
Ä¿µÄµØ£º RA_CONTACTS.JOB_TITLE

CONTACT_ LAST_NAME

ÊäÈëÁªÏµÈ˵ÄÐÕ¡£Èç¹ûÄúÌîÈëÁË ORIG_SYSTEM_CONTACT_REF£¬Ôò±ØÐëÔÚ´ËÀ¸ÖÐÊäÈëÖµ¡£·ñÔò£¬´ËÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º RA_CONTACTS.LAST_NAME

CONTACT_TITLE

ÊäÈë´ËÁªÏµÈ˵Äְλ¡£´ËÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º AR_LOOKUPS.LOOKUP_CODE£¬´Ë´¦ LOOKUP_TYPE = 'CONTACT_TITLE'¡£
Ä¿µÄµØ£º RA_CONTACTS.TITLE

CREATED_BY

ÊäÈë´´½¨´ËÐеÄÓû§±êʶ¡£´ËÀ¸ÎªÒªÇóÀ¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º ÎÞ

CREATION_DATE

ÊäÈëϵͳÈÕÆÚ¡£´ËÀ¸ÎªÒªÇóÀ¸¡£

ÑéÖ¤£º ±ØÐëΪÓÐЧµÄÈÕÆÚ¸ñʽ¡£
Ä¿µÄµØ£º ÎÞ

INTERFACE_STATUS

´ËÀ¸ÓÉ¿Í»§½Ó¿ÚʹÓã¬Ó¦±£ÁôΪ¿Õ¡£¿Í»§½Ó¿Ú³ÌÐò½«ÒÔÓ¦ÓÃÓڴ˽ӿڼǼµÄËùÓдíÎóÐÅÏ¢À´¸üдËÀ¸¡£Èç¹û½Ó¿Ú¼Ç¼´æÔÚ¶à¸öÎÊÌ⣬Ôò¿Í»§½Ó¿Ú³ÌÐò½«ÒÔ¶à¸ö´íÎó´úÂëÀ´¸üдËÀ¸¡£

INSERT_ UPDATE_FLAG

ÊäÈëÖµÒÔÖ¸Ã÷ÊÇ·ñ²åÈëмǼ»ò¸üÐÂÏÖÓмǼ¡£´ËÀ¸ÎªÒªÇóÀ¸¡£

ÑéÖ¤£º 'I' ±íʾ²åÈ룬'U' ±íʾ¸üС£
Ä¿µÄµØ£º ÎÞ

LAST_UPDATED_ BY

ÊäÈë¸üдËÐеÄÓû§±êʶ¡£´ËÀ¸ÎªÒªÇóÀ¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º RA_PHONES.ATTRIBUTE1 µ½ 15

LAST_UPDATE_ DATE

ÊäÈëϵͳÈÕÆÚ¡£´ËÀ¸ÎªÒªÇóÀ¸¡£

ÑéÖ¤£º ±ØÐëΪÓÐЧµÄÈÕÆÚ¸ñʽ¡£
Ä¿µÄµØ£º ÎÞ

LAST_UPDATE_ LOGIN

ÊäÈë×¢²á±êʶ¡£´ËÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º ÎÞ

ORIG_SYSTEM_ CUSTOMER_REF

ÊäÈëÒ»¸ö¿ÉÓÃÀ´Ö»Ê¶±ðԭʼϵͳÖеĴ˿ͻ§µÄÖµ¡£

ÑéÖ¤£º ±ØÐëµÈÓÚÒª¸üÐ嵀 RA_CUSTOMERS.ORIG_SYSTEM_ REFERENCE¡£Èç¹ûÄúÒªÊäÈëÁªÏµÈË»òµç»°ÐÅÏ¢£¬Ôò±ØÐëÔÚ´ËÀ¸ÖÐÊäÈëÖµ¡£
Ä¿µÄµØ£º RA_CUSTOMERS.ORIG_SYSTEM_REFERENCE

ORIG_SYSTEM_ ADDRESS_REF

ÊäÈëÒ»¸ö¿ÉÓÃÀ´Ö»Ê¶±ðԭʼϵͳÖеĴ˵ØÖ·µÄÖµ¡£

Èç¹û´ËÀ¸Îª¿Õ£¬ÔòÄúÊäÈëµÄµç»°»òÁªÏµÈËÓë¿Í»§Ïà¹Ø¡£

ÑéÖ¤£º ±ØÐëµÈÓÚÒª¸üÐ嵀 RA_ADDRESSES.ORIG_SYSTEM_ REFERENCE¡£Èç¹ûÄúÒªÊäÈëÓëµØÖ·Ïà¹ØµÄÐÅÏ¢£¬ÈçÁªÏµÈË»òµç»°£¬Ôò±ØÐëÔÚ´ËÀ¸ÖÐÊäÈëÖµ¡£
Ä¿µÄµØ£º RA_ADDRESSES.ORIG_SYSTEM_REFERENCE

ORIG_SYSTEM_ CONTACT_REF

ÊäÈëÒ»¸ö¿ÉÓÃÀ´Ö»Ê¶±ðԭʼϵͳÖеĴËÁªÏµÈ˵ÄÖµ¡£

´ËÀ¸ÊÇ RA_CONTACT_PHONES_INTERFACE Ö÷¹Ø¼ü×ÖµÄÒ»²¿·Ö¡£Ö÷¹Ø¼ü×ÖÊÇ ORIG_SYSTEM_CONTACT_REF ºÍ ORIG_SYSTEM_TELEPHONE_REF µÄ×éºÏ¡£

ÒªÊäÈë¿Í»§µÄÁªÏµÈË£¬ÇëÎðÔÚ ORIG_SYSTEM_ADDRESS_REF ÖÐÊäÈëÖµ¡£

Èç¹ûÄúÒªÊäÈëÌض¨µØÖ·µÄÁªÏµÈË£¬ÇëͬʱÔÚ ORIG_ SYSTEM_CUSTOMER_REF ºÍ ORIG_SYSTEM_ADDRESS_REF ÖÐÊäÈëÖµ¡£

ÑéÖ¤£º ±ØÐëµÈÓÚÒª¸üÐ嵀 RA_CONTACTS.ORIG_SYSTEM_ REFERENCE¡£Èç¹ûÄúÒªÊäÈëÁªÏµÈËÐÅÏ¢»òÓëÁªÏµÈËÏà¹ØµÄÐÅÏ¢£¬ÈçÖ¸¶¨ÖÁÁªÏµÈ˵ĵ绰ºÅÂ룬Ôò±ØÐëÔÚ´ËÀ¸ÖÐÊäÈëÖµ¡£
Ä¿µÄµØ£º RA_CONTACTS.ORIG_SYSTEM_REFERENCE

ORIG_SYSTEM_ TELEPHONE_REF

ÊäÈëÒ»¸ö¿ÉÓÃÀ´Ö»Ê¶±ðԭʼϵͳÖеĴ˵绰µÄÖµ¡£

´ËÀ¸ÊÇ RA_CONTACT_PHONES_INTERFACE Ö÷¹Ø¼ü×ÖµÄÒ»²¿·Ö¡£Ö÷¹Ø¼ü×ÖÊÇ ORIG_SYSTEM_CONTACT_REF ºÍ ORIG_SYSTEM_TELEPHONE_REF µÄ×éºÏ¡£

ÒªÊäÈë¿Í»§µÄµç»°£¬ÇëÎðÔÚ ORIG_SYSTEM_ADDRESS_REF »ò ORIG_SYSTEM_CONTACT_REF ÖÐÊäÈëÖµ¡£

ÒªÊäÈëÌض¨µØÖ·µÄµç»°£¬ÇëÔÚ ORIG_SYSTEM_CUSTOMER_REF ºÍ ORIG_SYSTEM_ADDRESS_ REF ÖÐÊäÈëÖµ¡£

ÒªÊäÈëÌض¨ÁªÏµÈ˵ĵ绰£¬ÇëÔÚ ORIG_SYSTEM_CUSTOMER_REF¡¢ORIG_SYSTEM_CONTACT_REF ºÍ ORIG_SYSTEM_ADDRESS_REF ÖÐÊäÈëÖµ£¨Èç¹ûÁªÏµÈËÓëµØÖ·Ïà¹ØÁª£©¡£

ÑéÖ¤£º ±ØÐëµÈÓÚ RA_PHONES.ORIG_SYSTEM_ REFERENCE¡£ÔÚÖ¸¶¨µç»°ÐÅϢʱ±ØÐëÊäÈë´ËÀ¸¡£
Ä¿µÄµØ£º RA_PHONES.ORIG_SYSTEM_REFERENCE

REQUEST_ID

´ËÀ¸ÓÉ¿Í»§½Ó¿ÚʹÓã¬Ó¦±£ÁôΪ¿Õ¡£

TELEPHONE

ÊäÈë¿Í»§¡¢µØÖ·»òÁªÏµÈ˵ĵ绰ºÅÂë¡£

ÑéÖ¤£º ÔÚÖ¸¶¨µç»°ÐÅϢʱ±ØÐëÊäÈë´ËÀ¸£¨ÀýÈ磬Èç¹ûÌîÈëÁË ORIG_SYSTEM_TELEPHONE_REF£©¡£
Ä¿µÄµØ£º RA_PHONES.PHONE_NUMBER

TELEPHONE_ AREA_CODE TELEPHONE_ EXTENSION

È¡¾öÓÚËùÑ¡ÔñµÄÀ¸£¬ÊäÈëµç»°ºÅÂëµÄÇøÓò´úÂë»ò·Ö»ú¡£ÕâЩÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º RA_PHONES.AREA_CODE RA_PHONES.EXTENSION

TELEPHONE_TYPE

ÊäÈëµç»°ºÅÂëµÄÀàÐÍ£¬ÈçͨÓᢴ«Õæ»òµç´«¡£Äú¿ÉÒÔʹÓÃÏÈÇ°ÔÚ¡°¿ìËÙ±àÂ롱´°¿ÚÖÐÒÔ¡°¿Í»§ÁªÏµÍ¨ÐÅÀàÐÍ¡±¿ìËÙ±àÂëÀàÐÍÀ´¶¨ÒåµÄµç»°ÀàÐÍ¡£

Í
ÑéÖ¤£º AR_LOOKUPS.LOOKUP_CODE£¬´Ë´¦ LOOKUP_TYPE = 'COMMUNICATION_TYPE'¡£ÔÚÖ¸¶¨µç»°ÐÅϢʱ±ØÐëÊäÈë´ËÀ¸£¨ÀýÈ磬Èç¹ûÌîÈëÁË ORIG_SYSTEM_TELEPHONE_REF£©¡£
Ä¿µÄµØ£º RA_CONTACTS.PHONE_TYPE

VALIDATED_FLAG

´ËÀ¸ÓÉ¿Í»§½Ó¿ÚʹÓã¬Ó¦±£ÁôΪ¿Õ¡£

RA_CUSTOMER_BANKS_INTERFACE

´Ë±í´æ´¢¿Í»§»òÌض¨¡°¿ªµ¥ÖÁ¡±µØÖ·µÄÒøÐÐÐÅÏ¢¡£Èç¹ûÄú²»²åÈë»òÖ¸¶¨¿Í»§ÒøÐÐÐÅÏ¢£¬ÔòÎÞÐëÔڴ˱íÖÐÊäÈëÖµ¡£Èç¹û×Ô¶¯¸¶¿î·½·¨Óë¿Í»§»ò¿Í»§µÄ¡°¿ªµ¥ÖÁ¡±ÒµÎñÄ¿µÄÏà¹ØÁª£¬Ôò±ØÐëÊäÈë´Ë¿Í»§µÄÒøÐÐÕÊ»§¡£

À¸Ãû

Öµ

ATTRIBUTE_ CATEGORY

ÊäÈë˵Ã÷ÐÔµ¯ÐÔÓòÀà±ðÐÅÏ¢¡£´ËÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º AP_BANK_ACCOUNT_USES.ATTRIBUTE_ CATEGORY

ATTRIBUTE 1 µ½ 15

ÊäÈë˵Ã÷ÐÔµ¯ÐÔÓòÐÅÏ¢¡£´ËÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º AP_BANK_ACCOUNT_USES.ATTRIBUTE 1 µ½ 15

BANK_ ACCOUNT_NUM BANK_ACCOUNT_ CURRENCY_CODE

È¡¾öÓÚËùÑ¡ÔñµÄÀ¸£¬ÊäÈë´ËÒøÐÐÕÊ»§µÄÕʺŻò±ÒÖÖ´úÂë¡£´Ë±àºÅ±ØÐëÊÇ·ÖÐеÄΨһ±àºÅ¡£

ÑéÖ¤£º Èç¹ûÒøÐÐÕÊ»§ÒѾ­´æÔÚ£¬ÇëÎðÊäÈëÖµ¡£Èç¹ûÒøÐÐÕÊ»§²»´æÔÚ£¬Ôò±ØÐëÊäÈëÖµ¡£
Ä¿µÄµØ£º AP_BANK_ACCOUNT.BANK_ACCOUNT_NUM AP_BANK_ACCOUNTS.CURRENCY_CODE

BANK_ACCOUNT_ INACTIVE_DATE

ÊäÈë´ËÒøÐÐÕË»§Ê§Ð§µÄÈÕÆÚ¡£´ËÀ¸Îª¿ÉÑ¡Ïî

ÑéÖ¤£º ±ØÐëΪÓÐЧµÄÈÕÆÚ¸ñʽ¡£
Ä¿µÄµØ£º AP_BANK_ACCOUNTS.INACTIVE_DATE

BANK_ACCOUNT_ DESCRIPTION

ÊäÈë´ËÒøÐÐÕÊ»§µÄ˵Ã÷¡£´ËÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º AP_BANK_ACCOUNTS.DESCRIPTION

BANK_ ACCOUNT_CHECK_ DIGITS

ÊäÈë֧ƱÉÏ´òÓ¡µÄ´ËÒøÐÐÕÊ»§±àºÅ¡£´ËÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º AP_BANK_ACCOUNT.CHECK_DIGITS

BANK_ ACCOUNT_NAME

ÊäÈëÖ¸¶¨ÖÁ´Ë¿Í»§»ò¡°¿ªµ¥ÖÁ¡±µØÖ·µÄÒøÐÐÕÊ»§Ãû¡£Äú¿ÉÒÔʹÓá°ÒøÐС±´°¿ÚÀ´¶¨Òå¿Í»§µÄÒøÐкÍÒøÐÐÕÊ»§¡£Èç¹ûÉÐ䶨ÒåÒøÐÐÕÊ»§£¬Ôò¿Í»§½Ó¿Ú½«»áÔÚ AP_BANK_ACCOUNTS Öд´½¨ÒøÐÐÕË»§¡£´ËÀ¸ÎªÒªÇóÀ¸¡£

ÑéÖ¤£º ±ØÐë´æÔÚÓÚ AP_BANK_ACCOUNTS ÖУ¬Èç¹û²»´æÔÚ£¬Ôò±ØÐë´æÔÚÓÚ BANK_ACCOUNT_CURRENCY_CODE¡¢BANK_ACCOUNT_NUM, BANK_NAME ºÍ BANK_BRANCH_NAME ÖС£
Ä¿µÄµØ£º AP_BANK_ACCOUNTS.BANK_ACCOUNT_ NAME

BANK_NAME BANK_ BRANCH_NAME

ÊäÈëÄúÒª²åÈëµÄÒøÐлò·ÖÐÐÕÊ»§Ãû³Æ¡£Èç¹ûÒøÐÐÕÊ»§²»´æÔÚ£¬Ôò±ØÐëÊäÈëÖµ¡£

ÑéÖ¤£º BANK_NAME Óë BANK_BRANCH_NAME ÅäºÏµÄÖµ±ØÐëÊÇΨһֵ¡£Èç¹ûÒøÐÐÕÊ»§ÒѾ­´æÔÚ£¬ÇëÎðÊäÈëÖµ¡£Èç¹û䶨ÒåÒøÐÐÕÊ»§£¬Ôò±ØÐëÊäÈë Bank_Branch_Name¡£
Ä¿µÄµØ£º AP_BANK_ACCOUNTS.BANK_NAME AP_BANK_BRANCHES.BANK_BRANCH_NAME

BANK_NUMBER

ÊäÈëÓëÒøÐÐÕÊ»§Ïà¹ØÁªµÄÒøÐбàºÅ¡£

ÑéÖ¤£º ±ØÐëΪΨһֵ¡£Èç¹ûÒøÐÐÕÊ»§ÒѾ­´æÔÚ£¬ÇëÎðÊäÈëÖµ¡£Èç¹ûÒøÐÐÕÊ»§²»´æÔÚ£¬Ôò´ËÀ¸Îª¿ÉÑ¡À¸¡£
Ä¿µÄµØ£º AP_BANK_BRANCHES.BANK_NUMBER

BANK_NUM

ÊäÈëÓëÄúÒª²åÈëµÄÒøÐÐÕÊ»§Ïà¹ØÁªµÄ·ÖÐбàºÅ¡£

ÑéÖ¤£º ±ØÐëΪΨһֵ¡£Èç¹ûÒøÐÐÕÊ»§ÒѾ­´æÔÚ£¬ÇëÎðÊäÈëÖµ¡£Èç¹ûÒøÐÐÕÊ»§²»´æÔÚ£¬Ôò´ËÀ¸Îª¿ÉÑ¡À¸¡£
Ä¿µÄµØ£º AP_BANK_BRANCHES.BANK_NUM

BANK_ACCOUNT_ DESCRIPTION

ÊäÈë´Ë·ÖÐеÄ˵Ã÷¡£´ËÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º AP_BANK_BRANCHES.DESCRIPTION

BANK_BRANCH_ ADDRESS 1 µ½ 4

ÊäÈë´Ë·ÖÐеĽֵÀµØÖ·¡¢³ÇÊС¢ÏØ¡¢ÖÝ¡¢ÓÊÕþ±àÂë»òÊ¡¡£ÕâЩÀ¸Îª¿ÉÑ¡À¸¡£

BANK_ BRANCH_CITY

BANK_ BRANCH_COUNTY

BANK_ BRANCH_STATE

BANK_ BRANCH_ZIP

BANK_ BRANCH_PROVINCE

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º AP_BANK_BRANCHES.ADDRESS_LINE1-3 AP_BANK_BRANCHES.CITY AP_BANK_BRANCHES.STATE AP_BANK_BRANCHES.ZIP AP_BANK_BRANCHES.PROVINCE

ÊäÈë´Ë·ÖÐеĹú¼Ò/µØÇø¡£´ËÀ¸Îª¿ÉÑ¡À¸¡£

BANK_ BRANCH_COUNTRY

ÑéÖ¤£º ±ØÐë´æÔÚÓÚ FND_TERRITORIES.TERRITORY_CODE ÖС£
Ä¿µÄµØ£º AP_BANK_BRANCHES.COUNTRY

BANK_ BRANCH_PHONE

ÊäÈë´Ë·ÖÐеĵ绰ºÅÂë»òµç»°ÇøÓò´úÂë¡£ÕâЩÀ¸Îª¿ÉÑ¡À¸¡£

BANK_ BRANCH_ AREA_CODE

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º AP_BANK_BRANCHES.PHONE AP_BANK_BRANCHES.AREA_CODE

BANK_BRANCH_EFT_USER_NUMBER

ÊäÈëµç×Ó×ʽðתÕÊÓû§±êʶ¡£´ËÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º AP_BANK_BRANCHES.EFT_USER_NUMBER

BANK_ACCOUNT_ ATT_CATEGORY

ÊäÈë˵Ã÷ÐÔµ¯ÐÔÓòÀà±ðÐÅÏ¢¡£ÕâЩÀ¸Îª¿ÉÑ¡À¸¡£

BANK_ BRANCH_ ATT_CATEGORY

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º AP_BANK_ACCOUNTS.ATTRIBUTE_ CATEGORY AP_BANK_BRANCHES.ATTRIBUTE_CATEGORY

BANK_ACCOUNT_ ATTRIBUTE 1 µ½ 15

ÊäÈë˵Ã÷ÐÔµ¯ÐÔÓòÐÅÏ¢¡£ÕâЩÀ¸Îª¿ÉÑ¡À¸¡£

BANK_ BRANCH_ ATTRIBUTE 1 µ½ 15

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º AP_BANK_ACCOUNTS.ATTRIBUTE1 µ½ 15 AP_BANK_BRANCHES.ATTRIBUTE1 µ½ 15

CREATED_BY

ÊäÈë´´½¨´ËÐеÄÓû§±êʶ¡£´ËÀ¸ÎªÒªÇóÀ¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º ÎÞ

CREATION_DATE

ÊäÈëϵͳÈÕÆÚ¡£´ËÀ¸ÎªÒªÇóÀ¸¡£

ÑéÖ¤£º ±ØÐëΪÓÐЧµÄÈÕÆÚ¸ñʽ¡£
Ä¿µÄµØ£º ÎÞ

END_DATE

ÊäÈë´ËÒøÐÐÕÊ»§Ê§Ð§µÄÈÕÆÚ¡£´ËÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º ÖÕÖ¹ÈÕÆÚ²»ÄÜÔçÓÚÆðʼÈÕÆÚ£»Ö»ÓÐÔÚûÓÐÖصþµÄÈÕÆÚ·¶Î§Ê±£¬Äú²Å¿ÉÒÔ½«¿Í»§Ö¸¶¨ÖÁ¶à¸öÒøÐÐÕÊ»§£»´ËÈÕÆÚ±ØÐëΪÓÐЧµÄÈÕÆÚ¸ñʽ¡£
Ä¿µÄµØ£º AP_BANK_ACCOUNT_USES.END_DATE

INTERFACE_STATUS

´ËÀ¸ÓÉ¿Í»§½Ó¿ÚʹÓã¬Ó¦±£ÁôΪ¿Õ¡£¿Í»§½Ó¿Ú³ÌÐò½«ÒÔÓ¦ÓÃÓڴ˽ӿڼǼµÄËùÓдíÎóÐÅÏ¢À´¸üдËÀ¸¡£Èç¹û½Ó¿Ú¼Ç¼´æÔÚ¶à¸öÎÊÌ⣬Ôò¿Í»§½Ó¿Ú³ÌÐò½«ÒÔ¶à¸ö´íÎó´úÂëÀ´¸üдËÀ¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º ÎÞ

LAST_UPDATED_ BY

ÊäÈë¸üдËÐеÄÓû§±êʶ¡£´ËÀ¸ÎªÒªÇóÀ¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º ÎÞ

LAST_UPDATE_ DATE

ÊäÈëϵͳÈÕÆÚ¡£´ËÀ¸ÎªÒªÇóÀ¸¡£

ÑéÖ¤£º ±ØÐëΪÓÐЧµÄÈÕÆÚ¸ñʽ¡£
Ä¿µÄµØ£º ÎÞ

LAST_UPDATE_ LOGIN

ÊäÈë×¢²á±êʶ¡£´ËÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º ÎÞ

ORIG_SYSTEM_ CUSTOMER_REF

ÊäÈë´ú±íÄúÒª²åÈëÒøÐÐÐÅÏ¢µÄ¿Í»§µÄÖµ¡£´ËÀ¸ÎªÒªÇóÀ¸¡£

ÑéÖ¤£º ¿Í»§²Î¿¼±ØÐë´æÔÚÓÚ RA_CUSTOMERS ÖлòÔÚ RA_CUSTOMERS_INTERFACE Öгɹ¦µØ½øÐÐÁËÑéÖ¤¡£
Ä¿µÄµØ£º AP_BANK_ACCOUNT_USES.CUSTOMER_ID£¨´Ó ORIG_SYSTEM_CUSTOMER_REF µ¼³ö£©

ORIG_SYSTEM_ ADDRESS_REF

ÊäÈë´ú±íÄúÒª²åÈëÒøÐÐÐÅÏ¢µÄ¿Í»§µØÖ·µÄÖµ£»ÓÐЧµÄ¡°¿ªµ¥ÖÁ¡±ÒµÎñÄ¿µÄ±ØÐëÓë´ËµØÖ·Ïà¹ØÁª£»½öÔÚÄúÒª²åÈëÌض¨¡°¿ªµ¥ÖÁ¡±µØÖ·µÄÒøÐÐÐÅϢʱ²ÅÒªÇóÊäÈë´ËÀ¸¡£

ÑéÖ¤£º ¶ÔÓÚ²åÈ룬µØÖ·²Î¿¼±ØÐë´æÔÚÓÚ RA_ADDRESSES ÖлòÔÚ RA_CUSTOMERS_INTERFACE Öгɹ¦µØ½øÐÐÁËÑéÖ¤£¨´Ó ORIG_SYSTEM_CUSTOMER_REF µ¼³ö£©¡£
Ä¿µÄµØ£º AP_BANK_ACCOUNT_USES.CUSTOMER_SITE_USE_ID

PRIMARY_FLAG

Ö¸Ã÷ÕâÊÇ·ñΪ´Ë¿Í»§»ò¡°¿ªµ¥ÖÁ¡±µØÖ·µÄÖ÷ÒªÒøÐÐÕÊ»§¡£´ËÀ¸ÎªÒªÇóÀ¸¡£

ÑéÖ¤£º ÊäÈë 'Y'£¨ÊÇ£©»ò 'N'£¨·ñ£©¡£¿Í»§²ã»òµØÖ·²ã½ö¿ÉÒÔ´æÔÚÒ»¸öÖ÷ÒªÒøÐÐÕÊ»§¡£
Ä¿µÄµØ£º AP_BANK_ACCOUNT_USES.PRIMARY_FLAG

REQUEST_ID

´ËÀ¸ÓÉ¿Í»§½Ó¿ÚʹÓã¬Ó¦±£ÁôΪ¿Õ¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º ÎÞ

START_DATE

ÊäÈë´ËÒøÐÐÕÊ»§ÉúЧµÄÆðʼÈÕÆÚ¡£´ËÀ¸ÎªÒªÇóÀ¸¡£

ÑéÖ¤£º ÖÕÖ¹ÈÕÆÚ²»ÄÜÔçÓÚÆðʼÈÕÆÚ£»ÔÚûÓÐÖصþµÄÈÕÆÚ·¶Î§Ê±£¬¿Í»§¿ÉÒÔÖ¸¶¨ÖÁ¶à¸öÒøÐÐÕÊ»§£»±ØÐëΪÓÐЧµÄÈÕÆÚ¸ñʽ¡£
Ä¿µÄµØ£º AP_BANK_ACCOUNT_USES.START_DATE

VALIDATED_FLAG

´ËÀ¸ÓÉ¿Í»§½Ó¿ÚʹÓã¬Ó¦±£ÁôΪ¿Õ¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º ÎÞ

RA_CUST_PAY_METHOD_INTERFACE

´Ë±í´æ´¢¿Í»§»òÌض¨¡°¿ªµ¥ÖÁ¡±µØÖ·µÄ¸¶¿î·½·¨ÐÅÏ¢¡£Èç¹û×Ô¶¯¸¶¿î·½·¨Óë¿Í»§»ò¿Í»§µÄ¡°¿ªµ¥ÖÁ¡±µØÖ·Ïà¹ØÁª£¬Ôò´Ë¿Í»§µÄÒøÐÐÕÊ»§±ØÐë´æÔÚ¡£Èç¹ûÄú²»¶Ô¿Í»§Ö¸¶¨¸¶¿î·½·¨£¬ÔòÎÞÐëÔڴ˱íÖÐÊäÈëÖµ¡£Äú²»ÄÜʹÓÿͻ§½Ó¿ÚÀ´²åÈ븶¿î·½·¨£¬¶ø±ØÐëʹÓá°¸¶¿î·½·¨¡±´°¿ÚÀ´´´½¨Ðµĸ¶¿î·½·¨¡£

À¸Ãû

Öµ

ATTRIBUTE_ CATEGORY

ÊäÈë˵Ã÷ÐÔµ¯ÐÔÓòÀà±ðÐÅÏ¢¡£´ËÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º RA_CUST_RECEIPT_METHODS.ATTRIBUTE_CATEGORY

ATTRIBUTE 1 µ½ 15

ÊäÈë˵Ã÷ÐÔµ¯ÐÔÓòÐÅÏ¢¡£´ËÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º RA_CUST_RECEIPT_METHODS.ATTRIBUTE 1 µ½ 15

CREATED_BY

ÊäÈë´´½¨´ËÐеÄÓû§±êʶ¡£´ËÀ¸ÎªÒªÇóÀ¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º ÎÞ

CREATION_DATE

ÊäÈëϵͳÈÕÆÚ¡£´ËÀ¸ÎªÒªÇóÀ¸¡£

ÑéÖ¤£º ±ØÐëΪÓÐЧµÄÈÕÆÚ¸ñʽ¡£
Ä¿µÄµØ£º ÎÞ

END_DATE

ÊäÈ븶¿î·½·¨Ê§Ð§µÄÈÕÆÚ¡£´ËÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º Ö»ÓÐÔÚûÓÐÖصþµÄÈÕÆÚ·¶Î§Ê±£¬Äú²Å¿ÉÒÔ½«¿Í»§Ö¸¶¨ÖÁ¶àÖÖ¸¶¿î·½·¨¡£´ËÈÕÆÚ±ØÐëΪÓÐЧµÄÈÕÆÚ¸ñʽ¡£
Ä¿µÄµØ£º RA_CUST_RECEIPT_METHODS.END_DATE

INTERFACE_STATUS

´ËÀ¸ÓÉ¿Í»§½Ó¿ÚʹÓã¬Ó¦±£ÁôΪ¿Õ¡£¿Í»§½Ó¿Ú³ÌÐò½«ÒÔÓ¦ÓÃÓڴ˽ӿڼǼµÄËùÓдíÎóÐÅÏ¢À´¸üдËÀ¸¡£Èç¹û½Ó¿Ú¼Ç¼´æÔÚ¶à¸öÎÊÌ⣬Ôò¿Í»§½Ó¿Ú³ÌÐò½«ÒÔ¶à¸ö´íÎó´úÂëÀ´¸üдËÀ¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º ÎÞ

LAST_UPDATED_ BY

ÊäÈë¸üдËÐеÄÓû§±êʶ¡£´ËÀ¸ÎªÒªÇóÀ¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º ÎÞ

LAST_UPDATE_ DATE

ÊäÈëϵͳÈÕÆÚ¡£´ËÀ¸ÎªÒªÇóÀ¸¡£

ÑéÖ¤£º ±ØÐëΪÓÐЧµÄÈÕÆÚ¸ñʽ¡£
Ä¿µÄµØ£º ÎÞ

LAST_UPDATE_ LOGIN

ÊäÈë×¢²á±êʶ¡£´ËÀ¸Îª¿ÉÑ¡À¸¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º ÎÞ

ORIG_SYSTEM_ CUSTOMER_REF

ÊäÈë´ú±íÄúÒª²åÈ븶¿î·½·¨µÄ¿Í»§µÄÖµ¡£´ËÀ¸ÎªÒªÇóÀ¸¡£

ÑéÖ¤£º ¿Í»§²Î¿¼±ØÐë´æÔÚÓÚ RA_CUSTOMERS ÖлòÔÚ RA_CUSTOMERS_INTERFACE Öгɹ¦µØ½øÐÐÁËÑéÖ¤¡£
Ä¿µÄµØ£º RA_CUST_RECEIPTS_METHODS.CUSTOMER_ID£¨´Ó ORIG_SYSTEM_CUSTOMER_REF µ¼³ö£©

ORIG_SYSTEM_ ADDRESS_REF

ÊäÈë´ú±íÄúÒª²åÈ븶¿î·½·¨µÄ¿Í»§µØÖ·µÄÖµ¡£ÓÐЧµÄ¡°¿ªµ¥ÖÁ¡±ÒµÎñÄ¿µÄ±ØÐëÓë´ËµØÖ·Ïà¹ØÁª£»½öÔÚÄúÒª²åÈëÌض¨¡°¿ªµ¥ÖÁ¡±µØÖ·µÄ¸¶¿î·½·¨Ê±²ÅÒªÇóÊäÈë´ËÀ¸¡£

ÑéÖ¤£º ´ËµØÖ·²Î¿¼±ØÐë´æÔÚÓÚ RA_ADDRESSES ÖлòÔÚ RA_CUSTOMERS_INTERFACE Öгɹ¦µØ½øÐÐÁËÑéÖ¤¡£
Ä¿µÄµØ£º RA_CUST_RECEIPT_METHODS.SITE_USE_ID£¨´Ó ORIG_SYSTEM_ADDRESS_REF µ¼³ö£©

PAYMENT_ METHOD_NAME

ÊäÈëÄúÒªÖ¸¶¨ÖÁ´Ë¿Í»§»ò¡°¿ªµ¥ÖÁ¡±µØÖ·µÄ¸¶¿î·½·¨Ãû³Æ¡£´ËÀ¸ÎªÒªÇóÀ¸¡£

ÑéÖ¤£º ±ØÐë´æÔÚÓÚ AR_RECEIPT_METHODS ÖС£
Ä¿µÄµØ£º RA_CUST_RECEIPTS_METHODS.RECEIPT_METHOD_ID£¨´Ó PAYMENT_METHOD_NAME µ¼³ö£©

PRIMARY_FLAG

ÊäÈë 'Y'£¨ÊÇ£©»ò 'N'£¨·ñ£©ÒÔÖ¸Ã÷ÕâÊÇ·ñΪ¿Í»§»ò¡°¿ªµ¥ÖÁ¡±µØÖ·µÄÖ÷Òª¸¶¿î·½·¨¡£´ËÀ¸ÎªÒªÇóÀ¸¡£

ÑéÖ¤£º ¿Í»§²ã»ò¡°¿ªµ¥ÖÁ¡±µØÖ·²ã½ö¿ÉÒÔ´æÔÚÒ»¸öÖ÷Òª¸¶¿î·½·¨¡£
Ä¿µÄµØ£º RA_CUST_RECEIPTS_METHODS.PRIMARY_FLAG

REQUEST_ID

´ËÀ¸ÓÉ¿Í»§½Ó¿ÚʹÓã¬Ó¦±£ÁôΪ¿Õ¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º ÎÞ

START_DATE

ÊäÈë´Ë¸¶¿î·½·¨ÉúЧµÄÆðʼÈÕÆÚ¡£´ËÀ¸ÎªÒªÇóÀ¸¡£

ÑéÖ¤£º Ö»ÓÐÔÚûÓÐÖصþµÄÈÕÆÚ·¶Î§Ê±£¬Äú²Å¿ÉÒÔ½«¿Í»§Ö¸¶¨ÖÁ¶àÖÖ¸¶¿î·½·¨¡£´ËÈÕÆÚ±ØÐëΪÓÐЧµÄÈÕÆÚ¸ñʽ¡£
Ä¿µÄµØ£º RA_CUST_RECEIPT_METHODS.START_DATE

VALIDATED_FLAG

´ËÀ¸ÓÉ¿Í»§½Ó¿ÚʹÓã¬Ó¦±£ÁôΪ¿Õ¡£

ÑéÖ¤£º ÎÞ
Ä¿µÄµØ£º ÎÞ

ÁíÇë²ÎÔÄ

¿Í»§µ¼Èë

ÓÉ¿Í»§½Ó¿Ú¸üеÄϵͳ±í

ÔËÐпͻ§½Ó¿ÚÒªÇóµÄ½Ó¿ÚÊý¾Ý

¿Í»§µ¼ÈëʵÀý

´´½¨Î¨Ò»µÄ¿Í»§²Î¿¼


         ÉÏÒ»Ò³  ÏÂÒ»Ò³          Ä¿Â¼  Ë÷Òý  ¶¨Î»  ´Ê»ã±í  ³ÌÐò¿â